RE: Suggestions solicited: How would YOU replicate FROM DB2 400 to SQL Server 7.0?

What about for a one-time occurance?

If someone wants to take records in DB2 files on the 400 and replicate them
in MS SQL just once, as in a conversion or to build test data, what would be
a good way to do that?

Can you do this with Java - connect to an as/400, get a result set, then
connect to NT and  insert the rows?

Phil



> -----Original Message-----
> From: owner-midrange-l@midrange.com
> [mailto:owner-midrange-l@midrange.com]On Behalf Of R. Bruce Hoffman, Jr.
> Sent: Tuesday, August 07, 2001 5:32 PM
> To: MIDRANGE-L@midrange.com
> Subject: Re: Suggestions solicited: How would YOU replicate FROM DB2 400
> to SQL Server 7.0?
>
>
>
> -----Original Message-----
> From: Schenck, Don <Don.Schenck@pfizer.com>
> To: 'midrange-l@midrange.com' <midrange-l@midrange.com>
> Date: Tuesday, August 07, 2001 8:34 AM
> Subject: Suggestions solicited: How would YOU replicate FROM DB2
> 400 to SQL
> Server 7.0?
>
>
> >Good day --
> >
> >How would YOU replicate data from tables in a DB2/400 database
> to table in
> a
> >SQL Server 7.0 database?
> >
>
> <Music swells in the background>
> SOUNDS LIKE A JOB FOR DATA PROP!!!
> <Fanfare of trumpets>
>
> Maybe with datajoiner... or whatever they call it these days
>
> >And how would you do it so that, say, it updates every 10 minutes?
> yup.
>
> >And it
> >does NOT completely replace the tables on every refresh. That is, it
> >replicates only new or changed or deleted records (can you replicate
> deleted
> >records? <grin>).
>
> Far as I know, yup. And yup, replicates deletes.
>
> >
>
>
> ===========================================================
> R. Bruce Hoffman, Jr.
>  -- IBM Certified Specialist - AS/400 Administrator
>  -- IBM Certified Specialist - RPG IV Developer
>
> "America is the land that fought for freedom and then
>   began passing laws to get rid of it."
>
>      - Alfred E. Neuman
>
>
> +---
> | This is the Midrange System Mailing List!
> | To submit a new message, send your mail to MIDRANGE-L@midrange.com.
> | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
> | To unsubscribe from this list send email to
> MIDRANGE-L-UNSUB@midrange.com.
> | Questions should be directed to the list owner/operator:
> david@midrange.com
> +---
>


_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com

+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---