SQLines Data Tool - Database Migration from Oracle to IBM DB2

SQLData is a scalable, high performance data transfer, schema conversion and validation tool for Oracle to IBM DB2 migration.

The tool requires connections to Oracle (OCI) and IBM DB2 (DB2 CLI driver) 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.

Scalability and High-Performance

• Transferring tables in multiple concurrent sessions
• Performing concurrent read and write operations in each session
• Using Oracle OCI with array processing to extract data from Oracle
• Using DB2 CLI API with array processing to load data to DB2
• Multi-threaded C/C++ application
• Linux and Windows

Migration Validation

• Comparing the number of rows in Oracle and DB2 tables
• Comparing data values in all columns

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

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 Oracle and DB2 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 Oracle and DB2, respectively.

This command transfers table emp from Oracle database to DB2 db_name database.

For list of options, see Command Line Reference.