AS/400 DB2 <----> SQL 2000 
Author Message
 AS/400 DB2 <----> SQL 2000

Does anyone know of a good source of documentation on how to replicate data
from an AS/400 DB2 database to a SQL Server 2000 database?

I imagine there are a few different ways to accomplish this task....I just
can't seem to find much documentation on how to do it, just that it can be
done.

HDR, DTS, Linked server etc...seems I could use any of these methods I just
don't see documentation explaining how to get one of these methods to
work...all leave out the technical details...

For the short term all I need is to be able to perform snapshot replication
from DB2 tables to a SQL Server...

Thanks in advance for any advice

James Glover
Eastridge Technology, Inc.



Mon, 19 Apr 2004 01:35:22 GMT
 AS/400 DB2 <----> SQL 2000

I wrote my own using VB. Although the applet is running
between AS/400 and Oracle 8i, I developed it against SQL
2K and then adjusted the syntax for Oracle. I didn't find
a good transfer/snapshot utility in my research. AS/400
has OLE DB, as does Oracle. It's pretty fast and is
scheduled to run daily. So far so good.

Quote:
>-----Original Message-----
>Does anyone know of a good source of documentation on how
to replicate data
>from an AS/400 DB2 database to a SQL Server 2000 database?

>I imagine there are a few different ways to accomplish
this task....I just
>can't seem to find much documentation on how to do it,
just that it can be
>done.

>HDR, DTS, Linked server etc...seems I could use any of

these methods I just
Quote:
>don't see documentation explaining how to get one of
these methods to
>work...all leave out the technical details...

>For the short term all I need is to be able to perform

snapshot replication
Quote:
>from DB2 tables to a SQL Server...

>Thanks in advance for any advice

>James Glover
>Eastridge Technology, Inc.

>.



Mon, 19 Apr 2004 02:08:41 GMT
 AS/400 DB2 <----> SQL 2000
We purchased transformation Server (www.datamirror.com) to do that for us


Quote:
> Does anyone know of a good source of documentation on how to replicate
data
> from an AS/400 DB2 database to a SQL Server 2000 database?

> I imagine there are a few different ways to accomplish this task....I just
> can't seem to find much documentation on how to do it, just that it can be
> done.

> HDR, DTS, Linked server etc...seems I could use any of these methods I
just
> don't see documentation explaining how to get one of these methods to
> work...all leave out the technical details...

> For the short term all I need is to be able to perform snapshot
replication
> from DB2 tables to a SQL Server...

> Thanks in advance for any advice

> James Glover
> Eastridge Technology, Inc.



Mon, 19 Apr 2004 15:37:05 GMT
 AS/400 DB2 <----> SQL 2000
In addition .. for short term and an equivalent snapshot, use DTS.

Look into DTS in BOL


Quote:
> I wrote my own using VB. Although the applet is running
> between AS/400 and Oracle 8i, I developed it against SQL
> 2K and then adjusted the syntax for Oracle. I didn't find
> a good transfer/snapshot utility in my research. AS/400
> has OLE DB, as does Oracle. It's pretty fast and is
> scheduled to run daily. So far so good.

> >-----Original Message-----
> >Does anyone know of a good source of documentation on how
> to replicate data
> >from an AS/400 DB2 database to a SQL Server 2000 database?

> >I imagine there are a few different ways to accomplish
> this task....I just
> >can't seem to find much documentation on how to do it,
> just that it can be
> >done.

> >HDR, DTS, Linked server etc...seems I could use any of
> these methods I just
> >don't see documentation explaining how to get one of
> these methods to
> >work...all leave out the technical details...

> >For the short term all I need is to be able to perform
> snapshot replication
> >from DB2 tables to a SQL Server...

> >Thanks in advance for any advice

> >James Glover
> >Eastridge Technology, Inc.

> >.



Mon, 19 Apr 2004 15:38:15 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

2. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

3. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

4. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

5. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

6. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

7. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

8. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

9. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

10. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

11. US-TX>>>PL/SQL Designers, HOUSTON<<<Yoh Information Technology

12. replication from SQL Server 2000 to DB2/400


 
Powered by phpBB® Forum Software