Importing Data Tables from DB2

[cricketer1]

How can I Import data tables from DB2 into MS Sql Server using DTS and Linked Server.

Thanks,
cricketer1

 

[philhege]

Here's a thread about linking to DB2:

http://groups.google.com/groups?hl=...um=1&prev=/groups?q=sql+server+link+DB2&hl=en

Then you could just issue a bunch of

SELECT * INTO MyNewTable from DB2linkserver.db.owner.MyOldTable

statements (and of course tweak for indices, relationships, triggers, constraints, defaults, etc., etc., etc.)

Hmmm. Sounds like there should be some tool out there for doing this. Time for some due diligence, eh?

Phil Hegedusich
Senior Web Developer
IIMAK

http://www.iimak.com

-----------
A priest, a lawyer, and a rabbi walk into a bar. The bartender looks up and says "What is this, a joke?

 

[cricketer1]

Thanks Phil, this is a real day saver!!