January 13, 2005 at 4:40 am
Firstly, am I able to migrate data from SQL2K to DB2. If so, can anyone please tell me how you do it. I have looked at BOL and can't find any mention of migrating data to DB2 using DTS.
thanks
T
January 13, 2005 at 5:38 am
I guess you have more luck looking for this information on the IBM site. Like this:
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
January 14, 2005 at 6:40 am
Frank's link has some good stuff. I would recommend you look at some of these things.
However, if you want to stick with just SQL and DB2, you can also do:
a) Set up your DB2 instance as a linked server, and use INSERT IINTO ... SELECT FROM ... to populate your DB2.
b) DB2 is ODBC compliant, and as DTS can output to any ODBC compliant interface you can pump data into DB2 from DTS.
c) You can use DB2 or SQL replication to transfer data.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply