There are many different ways to skin the data replication cat. Are you
looking to roll your own or do you want a canned solution?
As for TOAD for DB2 for i, have you looked at FROG?
http://www.innovativesys.net/?page_id=4
Brian May
Project Lead
Management Information Systems
Garan, Incorporated
Starkville, Mississippi
"Lance Gillespie" <LGillespie@xxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
04/15/2010 10:54 AM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
To
<midrange-l@xxxxxxxxxxxx>
cc
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
midrange.com
