RE: DB2/400 and MS SQL server

["Richard Schoen" <richard@xxxxxxxxxxxxxxx>]

Hello Lance, 

If you are open to commercial options, we have a product called RPG2SQL
Integrator that can be used to read/write data to SQL Server in
real-time from an RPG process. 

If you're interested feel free to download a FREE demo from our web
site.  

You will be writing data to SQL server in less than a couple hours and
our team will mentor you through getting started.  

Regards,
Richard Schoen
RJS Software Systems Inc.
Where Information Meets Innovation
Document Management, Workflow, Report Delivery, Forms and Business
Intelligence
Email: richard@xxxxxxxxxxxxxxx
Web Site: http://www.rjssoftware.com
Tel: (952) 736-5800
Fax: (952) 736-5801
Toll Free: (888) RJSSOFT


-----Original Message-----
message: 8
date: Thu, 15 Apr 2010 08:55:38 -0700
from: "Lance Gillespie" <LGillespie@xxxxxxxx>
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