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"Jep" <dontspam_jep@.jepweb.dk> wrote in message
news:d3g1kvk7p4ppe932pa5a8s7ncegruk6act@.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
