![]() Use the default schema in all DDL statements for Oracleįor more information, see SQLines Data Command Line Reference. Source database Informix, user, password, server and database database Oracle, user, password and SID (TNS name)Įxecute DROP TABLE and CREATE TABLE before loading data In this example the following options are set: exe -t =* -sd =informix,user db -td =oracle,user =transfer -topt =recreate -smap =*: Conclusion Some tools may support many database platforms but crash. The tool provides advanced logs including sqldata_ddl.sql a SQL file containing all executed SQL statements for Oracle, and sqldata_failed.sql a SQL file containing all failed SQL statements.įor example, to transfer all tables excluding system tables from Informix to Oracle, using the default schema in Oracle, recreating the existing tables, run: This article is a detailed comparison of the most notable data modeling tools in the market, according to their core features. Use the DB-Access program (dbaccess) to execute that file in the other database. ![]() SQLines Data allows you to easily automate the migration process using a command line. Use the DB-Schema program (dbschema) to get a text file containing (a banner line and) the DDL statements needed to create the table and its constraints, etc.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |