exchange data between db2 (as400) and ms sql server
-
Db2 is running on as400. We want to have a copy of the data on a windows server with ms sql server. a. Is there an odbc driver for db2 so we can query db2 from within ms sql server? b. More in general: how can we copy data from db2 to ms sql server and maybe automate this? c. what else do we need to know or is there some guide available online.
-
Db2 is running on as400. We want to have a copy of the data on a windows server with ms sql server. a. Is there an odbc driver for db2 so we can query db2 from within ms sql server? b. More in general: how can we copy data from db2 to ms sql server and maybe automate this? c. what else do we need to know or is there some guide available online.
There are a few ODBC drivers available for DB2. Google it up! As for copy data between DB2 and SQL Server. Is like a replication system or a one time only process? Do you want to transfer bulk volumes of data or small amounts of it? I dont know much about the performance aspects of it but if you had ODBC drivers for DB2, couldn't you just query the data from DB2 and insert it into SQL Server and vice versa?