SQLines Data is a scalable, high performance data transfer, schema conversion and validation tool for Informix to Oracle migration.

The tool requires connections to Informix (ODBC/CLI without ODBC Manager) and Oracle (OCI) databases. To convert SQL statements and scripts, use SQLines tool.

• Informix 11.x, 10.x, 9.x and 7.x
• Oracle 19c, 18c, 12c, 11g and 10g

SQLines Data benefits:

Advanced Database Schema Conversion Features

• Converting SERIAL columns to sequence and trigger in Oracle
• Supporting DATETIME data types with various time units (HOUR TO MINUTE, MINUTE TO SECOND etc.)
• Supporting TEXT, CLOB, BYTE and BLOB data transfer
• Converting identifiers exceeding 30 characters
• Resolving reserved word conflicts
• Automatically renaming indexes containing only digits in their names (generated by Informix for primary and foreign keys)

Migration Validation

• Comparing column data in each row taking into account data transformations
• Comparing the number of rows in Informix and Oracle tables

Scalability and High-Performance

• Transferring data in multiple concurrent sessions
• Performing concurrent read and write operations in each session
• Using Informix ODBC/CLI (without ODBC Manager) with array processing to extract data from Informix
• Using Oracle OCI with array processing to load data to Oracle
• Multithreaded C/C++ application

Designed for DBAs and Enterprise-Class Migrations

• Easy to set up and configure the transfer of a large number of tables
• Command line with powerful and easy to use options
• Wildcards to select and exclude tables
• No space required to hold Informix export
• No ADO.NET providers required
• No .NET dependency

Logging and Statistics

• Comprehensive performance stats to help you tune the data transfer
• Execution time for each DDL statement
• Read and write performance for each table (rows/sec and bytes/sec)
• Saving all executed DDL SQL statements into .sql file
• Saving all failed DDL SQL statements into a separate .sql file
• Summary performance information

Technical Support and Custom Solutions

• Direct support from the development team and migration experts
• Immediate software fixes and updates
• Custom features by request
• Email, phone and Skype

SQLines Data features and licensing:

	SQLines Data for Informix to Oracle Migration
Database Size
Data Volume	Unlimited
Number of Tables
Number of Rows
Number of Databases
Schema Conversion
CREATE TABLE Statement
SERIAL Columns
NOT NULL Constraints
DEFAULT Clauses
CHECK Constraints
Primary and Foreign Keys
Unique Constraints
Indexes
Schema Transformation
Schema Name Mapping
Reserved Words
Validation
Validation by Row Count
Full Data Validation
Performance and Scalability
Parallel Sessions	Unlimited
Concurrent Reader/Writer in Each Session
32-bit Version
Automation
Command Line
Licensing and Support
Technical Support

Download a Trial Version of SQLines Data.

If any you have any questions or need any assistance, please contact us at support@sqlines.com.

For detailed information about conversion features supported in SQLines Data, see Informix to Oracle Migration Reference.

SQLines Data allows you to easily automate the migration process using a command line.

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.

For example, to transfer all tables excluding system tables from Informix to Oracle, using the default schema in Oracle, recreating the existing tables, run:

sqldata.exe -t=* -sd=informix,user/pwd@ol_informix, db -td=oracle,user/pwd@sid
                         -cmd=transfer -topt=recreate -smap=*:

In this example the following options are set:

For more information, see SQLines Data Command Line Reference.