Re: How to Restore AS400 data to SQl Server

[Vern Hamberg <vhamberg@xxxxxxxxxxx>]

Rob - gotta do it!!

<verndor response>
As one of "those" we have a product called RPG2SQL Integrator - it's an 
SDK for handling data on remote SQL-based database systems from your 
RPGLE programs. Look at our site at http://www.rjssoftware.com or call 
us at 888.rjs.soft for more information.
</verndor response>

Regards
Vern

BTW, I guess I'm the primary developer of the iSeries end of things, now.

rob@xxxxxxxxx wrote:
> Normally it's done one of two ways.
> 1 - Search for JDBC and use a JDBC connection to transfer data.  Craig 
> Pelkie wrote an article in the July/August 2005 Volume 8, Number 4 edition 
> of iSeries 400 Experts Journal entitled "Using Java to access Microsoft 
> SQL Server from RPG".
> 2 - Use the SPENDMONEY command and buy one of the tools who should be 
> offering their solutions on the list any second now...
> (Vendors - I have no problem with that and did not mean to infer that I 
> do.)
>
> Other options are more cryptic and may involve something like exporting 
> your DB2 files to stream files (like tab delimited) and them attempting to 
> import those into SQL Server.  I would think the loss of column 
> definitions etc would be less than desirable.
>
> Rob Berendt
>