October 25, 2006 at 2:43 pm
Hello. What would be the best way to transfer data from DB2 to SQL Server 2000? Any feedback/suggestion is appreciated!
October 26, 2006 at 12:42 am
As Far as I Know, you have to see a local IBM authorized distributor to get a DB2 reader utility serving to convert data from DB2 to SQL. In addition, when you buy machine of AS/400 server to run DB2, I think, you got a package with this attached utility.
October 26, 2006 at 3:36 am
Easy.
You have to install and configure the DB2 client on your SqlServer box. Then you can use it as an ODBC server. So you can use it as linked server or DTS connection.
For get the optipal performance you should define your queries as pass trough query like this one:
Select * from openquery(MYDB2, 'select x, y from db2shema.db2table where z=10 fetch first 100 rows only')
Bye
Gabor
October 26, 2006 at 8:43 am
I've just been doing this, using the IBM client access tools to give me an odbc driver, and then setting up the db2 server as a linked server. It's pretty fiddly I'm afraid.
Make sure you have the latest patches of the IBM client access tools, I was a patch behind and it made me get stuck for a day.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply