|
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 +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.