By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,854 Members | 1,912 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,854 IT Pros & Developers. It's quick & easy.

Copying data from SQL2000 to DB2 8.1

P: n/a
Jep


I have to setup some scheduled tasks to copy 3-4 tables from an
SQL2000 database to DB2 v. 8.1.

The job must run every night replacing all data.

How can this be done - with standard utilities??
Please be exact - I'm new to this.
Thank for any help.
/Jep



Jul 20 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a

"Jep" <do**********@jepweb.dk> wrote in message
news:d3********************************@4ax.com...


I have to setup some scheduled tasks to copy 3-4 tables from an
SQL2000 database to DB2 v. 8.1.

The job must run every night replacing all data.

How can this be done - with standard utilities??
Please be exact - I'm new to this.
Thank for any help.
/Jep


Some possibilites are BCP, DTS and a linked server. BCP is used to copy
table data to a flat file - the file could then be transferred to the DB2
box and loaded with a similar DB2 utility. DTS is much more complex, but
includes workflow and can transfer data between many different sources. A
linked server would allow you to reference a DB2 table directly from SQL
Server, so you could do a simple INSERT ... SELECT...

All these options are covered in Books Online. If you don't have much
experience of using these tools, I'd suggest looking at BCP as a first
option - it's a command-line tool, and it's usually straightforward to use.

Whatever option you choose, you can use SQL Agent to schedule a job in
SQL2000 - see "Scheduling Jobs" in Books Online.

Simon
Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.