RE: replicate DB2 table to MS SQL

Why are you changing table layouts so much ? Seems like a suspect process.

If you really must you need something that can execute the SQL ALTER command from what it sounds.

Our RPG2SQL software is an option for running SQL server commands on-the-fly and moving data.

There are probably other options as well.

Either way it sounds like a little custom programming.

Regards,


Richard Schoen
Director of Document Management
e. richard.schoen@xxxxxxxxxxxxxxx
p. 952.486.6802
w. helpsystems.com
------------------------------

message: 5
date: Tue, 21 Nov 2017 01:46:02 +0000
from: Mike Cunningham <mike.cunningham@xxxxxxx>
subject: replicate DB2 table to MS SQL

I have a need to replicate a DB2 table to MS SQL. I know I could manually create the MS SQL table with the same column names and attributes as the DB2 table and then coy the data between the two systems but the DB2 tables in question change on a fairly frequent basis. A column is added or dropped on average about once a week. (in reality its more like 4 changes made one time a month but average is one a week). I would prefer to just make the change to the DB2 table and have that change automatically replicated to the MS SQL table. In my case I can drop and recreate the MS SQL tables on every sync process so there would be no need to do an ALTER TABLE on the MS SQL side. Does anyone know of any utilities that might do this already so I don't need to grow my own utility?

Thanks
Mike Cunningham