How to copy tables fra MS SQL2000 to DB2

#1

I need to setup some automated jobs to copy data to a DB2 8.1 UDB.

Data has to be renewed every night.

One way woulkd be to unload to a text file and load from this, but I
hope there is a smarter way ??

Any help is greatly appreciated.
/Jep

#2

Larry <lsedels (AT) us (DOT) ibm.com> wrote

Quote:

Use DB2 Data Propagator (replication). Purchase and install DB2
Information Integrator Replication Edition.

Larry

Jep wrote:

I need to setup some automated jobs to copy data to a DB2 8.1 UDB.

Data has to be renewed every night.

One way woulkd be to unload to a text file and load from this, but I
hope there is a smarter way ??

Any help is greatly appreciated.
/Jep

Have you look into the DTS tool that comes with SQLServer?

#3

I would suggest DB2 replication (DB2 Data Propagator).

Jep wrote:

Quote:

I need to setup some automated jobs to copy data to a DB2 8.1 UDB.

Data has to be renewed every night.

One way woulkd be to unload to a text file and load from this, but I
hope there is a smarter way ??

Any help is greatly appreciated.
/Jep

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

How to copy tables fra MS SQL2000 to DB2

comp.databases.ibm-db2 comp.databases.ibm-db2

How to copy tables fra MS SQL2000 to DB2 - 08-15-2003 , 01:59 AM

Re: How to copy tables fra MS SQL2000 to DB2 - 08-15-2003 , 07:00 PM

Re: How to copy tables fra MS SQL2000 to DB2 - 08-16-2003 , 08:34 PM