SQLines Data - Database Migration from Informix to SQL Server

SQLines Data is a scalable, high performance data transfer, schema conversion and validation tool for Informix to Microsoft SQL Server (MSSQL, SQL Azure) migration.

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

SQLines Data benefits:

Migration Features

• All Data Types
• NOT NULL Constraints
• DEFAULT Clauses
• CHECK Constraints
• Primary and Foreign Keys
• Unique Constraints
• Indexes
• Comments on Tables and Columns
• Schema Name Mapping

You can use SQLines SQL Converter tool to convert stored procedures, functions, triggers, views and other objects.

Advanced Data Transformation Features

• Global and table level data type mapping
• Table and schema mapping
• Data filters (WHERE conditions)
• Computed columns and expressions
• Queries to define data to transfer
• Various DDL and data options

Advanced Database Migration Features

• Tables Exceeding the maximum allowable table row size of 8060 bytes
• Tables exceeding the maximum of 1024 columns

Scalability and High-Performance

• Transferring tables 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 SQL Server Native Client Bulk Copy API to insert data to SQL Server
• Multi-threaded C/C++ Application
• Linux and Windows

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 tables
• Comprehensive performance stats to help you tune the data transfer
• No space required to hold Informix export
• No ADO.NET providers required
• No .NET dependency
• No installation required

Migration Validation

• Comparing the number of rows in Informix and SQL Server tables
• Comparing data values in all columns

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

You can use SQLines Data tool in command line. Just launch sqldata.exe on Windows or ./sqldata on Linux with the specified options.

For information how to set up Informix and SQL Server connections, see SQLines Data Connection String Formats.

Examples:

• Transfer a single table

-t option defines the table name, -sd and -td options (source and target databases) specify the connection strings for Informix and SQL Server, respectively.

This command transfers table emp from Informix database to SQL Server db_name database.

For list of options, see Command Line Reference.