Return
-
Title
Is it possible to transfer data from a DB2 database to a SQL Server database using Toad? -
Description
Is it possible to transfer data from a DB2 database to a SQL Server database using Toad for DB2 and Toad for SQL Server respectively?
-
Resolution
If you're trying to transfer data in a DB2 table to a SQL Server table, please try the following steps:
1. In Toad for DB2, export the data from the table to an Excel (.xls) file.
2. Open Toad for SQL Server and create a new table which is identical to the DB2 table.
3. Using the Import Wizard, in Toad for SQL Server, import the data from the saved DB2 table into the newly created SQL Server table.