Re: Data Transfer

[DrFranken <midrange@xxxxxxxxxxxx>]

Now why in the world would you want to do THAT!?

The likely simple way for one time transfers is to use ACS to create a 
download in the sequence needed for the MS DB.

If this is not a one time thing then it gets much more complicated.  "I 
know a guy" who writes this stuff which runs on IBM i using Java and C 
to push and pull date to MSSQL on the fly. It is used primarily when 
someone decides (in error) that you can't do 'web things' on IBM i so 
they demand use of an inferior server for that.

        - Larry "DrFranken" Bolhuis

www.Frankeni.com
www.iDevCloud.com - Personal Development IBM i timeshare service.
www.iInTheCloud.com - Commercial IBM i Cloud Hosting.

On 5/15/2017 10:17 AM, Donna Crowley wrote:
> Good morning!
>
> Do any of you folks know of a product that would copy our DB2 data from our Power 8 to a MS server?  We don't have file layout from new vendor at this time, so it would be basically copying and pasting the data into an empty box.
>
> Thank you for any information / guidance you could pass my way.
> Donna
>
> Donna L. Crowley
> Information Systems Technician II
> Placer County Water Agency<http://www.pcwa.net/>
> Phone: (530) 823-4878
> Mobile:  (530) 308-5190
> Fax:  (530) 823-4812
> dcrowley@xxxxxxxx<mailto:dcrowley@xxxxxxxx>