Differences

This shows you the differences between two versions of the page.

--- sqldata:informix-to-postgresql [April 16, 2017 10:17 pm]
sqlines
+++ sqldata:informix-to-postgresql [July 18, 2024 12:20 pm] (current)
sqlines
@@ Line 1: / Line 1: @@
+====== 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 [[/informix-to-postgresql|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 [[/informix-to-postgresql|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**
+  * [[/informix-to-postgresql/zero_char_code_in_string|Zero character code in CHAR or VARCHAR]]
+**Migration Validation**
+  * Comparing the number of rows in Informix and PostgreSQL tables
+  * [[/informix-to-postgresql/data_validation|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 [[/sqldata_connection|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 [[/sqldata_cmd|Command Line Reference]].

SQLines Data

SQLines SQL Converter

Migration to MariaDB

Migration to MySQL

Migration to PostgreSQL

Migration to SQL Server

Migration to Oracle

SQL in Applications

Differences