Looking for a safe way to migrate your data from DB2 to SQL Server?
This simple, but very powerful tool is exactly what you need!
DB2Migrator is an intuitive and effective assistant for DB2 to SQL Server data migration. The tool transfers data from DB2 tables to existing SQL Server tables in a few easy steps. It is simple in use and advantageous in work.
The free trial version of DB2Migrator can be used for evaluation purposes for two days after the downloading. It migrates 10% of rows per each table, but not less than 100 rows. To enjoy full functionality of this product for unlimited period of time, you must buy a license.
How to use the tool
Execute the DB2MigratorSetup.msi file after it has been downloaded. During the installation, you should specify the folder for the program files and choose features to be installed. If you check “Launch DB2Migrator when setup exits” during the installation, the DB2Migrator wizard will be opened. Now you can start the migration!
Gordan R., Telecom Company
This tool has migrated our database in just one day, while we were focusing on more important things.
An wizard-like that allows the user to restart the migration from any step.
The tool uses the bulk copy mechanism to load data from DB2 tables to SQL Server. This approach allows it to achieve the maximum possible insertion speed.
You can edit the SELECT statement which reads the source data. This allows fixing many common data migration problems like incompatibilities in data types. Besides, it makes possible to perform a partial data migration, when you need to move only a definite range of records.
By creating a single migration task, you can migrate many tables at once. The target SQL Server database and schema can be specified only once for the whole task.
DB2Migrator has a Column Mapping feature, which allows establishing a custom correspondence between DB2 and SQL Server columns if necessary. This can occur, for example, when a DB2 column name happens to be a SQL Server keyword.
Current migration tasks can be saved in a file and restored later. Thus, you don't need to specify all parameters from scratch when you are repeating the migration for a similar set of tables on the same servers.
DB2Migrator requires the following software to be installed on your computer:
Windows Server 2003 or higher; Windows XP or higher
Microsoft .NET Framework 2.0
DB2 client 9.5 or later or Microsoft OLEDB provider for DB2 3.0 or later
You are downloading a free trial version of DB2Migrator. Keep in mind that with the trial version you can migrate 10% of rows per each table, but not less than 100 rows. Please purchase the license key to upgrade to the full version.