SQLines Data Tool - Database Migration from Informix to PostgreSQL

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

The tool requires connections to Informix (ODBC/CLI without ODBC Manager) and PostgreSQL (libpq C API) databases. To convert SQL statements and scripts, use SQLines SQL Converter tool.

Why SQLines Data

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 Schema Conversion Features

Supporting DATETIME data types with various time units (HOUR TO MINUTE, MINUTE TO SECOND etc.)
Supporting SERIAL columns
Supporting TEXT, CLOB, BYTE and BLOB data transfer

Advanced Database Migration Features

Zero character code in CHAR or VARCHAR

Migration Validation

Comparing the number of rows in Informix and PostgreSQL tables
Comparing column data in each row in Informix and PostgreSQL tables

Scalability and High-Performance

Transferring tables in multiple concurrent sessions
Performing concurrent read and write operations in each session
Using Informix ODBC/CLI (without Database Manager) with array processing to extract data from Informix
Using PostgreSQL libpq C API with COPY command to load data to PostgreSQL
Multithreaded 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 Oracle and PostgreSQL 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

SQLines Data in Command Line

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 and troubleshoot Informix and PostgreSQL connections, see SQLines Data Connection String Formats.

Examples:

Transfer a single table

sqldata -t=emp -sd=informix, user/pwd@ol_informix,db_name -td=pg,usr/pwd@localhost,pg_dbname

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

This command transfers table emp from Informix database to PostgreSQL pg_dbname database.

For list of options, see Command Line Reference.