SEO

#1 (**permalink**) 02-26-2008, 02:31 PM

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 (**permalink**) 02-26-2008, 02:31 PM

Larry <lsedels@us.ibm.com> wrote in message news:<3F3D0890.324050A3@us.ibm.com>...
> 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 (**permalink**) 02-26-2008, 02:31 PM

I would suggest DB2 replication (DB2 Data Propagator).

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
>
>
>

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

SEO

How to copy tables fra MS SQL2000 to DB2