RE: DB2/400 and MS SQL server

[Mike Cunningham <mike.cunningham@xxxxxxx>]

Goanywhere will also work if you want to control things from the iSeries side.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Don
Sent: Thursday, April 15, 2010 12:37 PM
To: 'Midrange Systems Technical Discussion'
Subject: RE: DB2/400 and MS SQL server


I think Linoma or Prodata have a package that will do what you're looking
for...



-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Lance Gillespie
Sent: Thursday, April 15, 2010 11:56 AM
To: midrange-l@xxxxxxxxxxxx
Subject: DB2/400 and MS SQL server

I am looking for a way populate a SQL Server table with
DB2/400 data.

In a perfect world I would be running this tool on the 
Windows box and it would update SQL server whenever the
DB2/400 data changes.  In a less perfect (but still OK)
world, it would update on a schedule.

Currently we ftp the DB2/400 data to the server as CSV
and use the Microsoft import tool.  This works, but lacks
aesthetic appeal.

I would also like to be able to use a TOAD-like tool from
a workstation against DB2/400 tables.

These could be different solutions.

I tried IBM DB2 CONNECT, but could not get it installed
properly before the evaluation period expired.

Vendor solutions welcome.

Thanks,
lance