SQLines Data is a scalable, high performance data transfer, schema conversion and validation tool for IBM DB2 to Microsoft SQL Server and SQL Azure migration.
SQLines Data benefits:
Migration Features
You can use SQLines SQL Converter tool to convert stored procedures, functions, triggers, views and other objects.
Scalability and High-Performance
Designed for DBAs and Enterprise-Class Migrations
You can use SQLines Data tool in command line. Just launch sqldata.exe on Windows with the specified options.
For information how to define DB2 and SQL Server connections, see SQLines Data Connection String Formats.
Examples:
sqldata -t=emp -sd=db2,db2user/db2user_pwd@sample_db -td=sql, sql_user/sql_pwd@server_host\instance,sql_db |
-t option defines the table name, -sd and -td options (source and target databases) specify the connection strings for DB2 and SQL Server, respectively.
This command transfers table emp from DB2 sample_db database to SQL Server sql_db database located on server_host\instance.
sqldata -t=emp -sd=db2,db2user/db2user_pwd@sample_db -td=sql, sql_user/sql_pwd@server_host\instance,sql_db -smap=*: |
The option -smap=*: specifies that the DB2 schema name is removed from all executed DDL statements in SQL Server, so all objects will be created in the default schema for the user (typically it is dbo).
For list of options, see Command Line Reference.
There are two main sources that can help you troubleshoot SQLines Data:
sqldata.log file contains the detailed information about DB2 to SQL Server migration process.
By default, sqldata.log file is located in the current working directory. You can use -log command line option to change its location and file name.
sqldata_ddl.sql file contains information about all DDL statements executed in SQL Server during migration.
In this file you can see the full SQL statements, the execution result (success or failure) and the execution time. In case of an error, you can find the error message returned by SQL Server.
By default, sqldata_ddl.sql file is located in the current working directory. You can use -out command line option to change its location.
If there are any failed SQL statements, you can find them in sqldata_failed.sql file.