Re: 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

________________________________
This email may contain confidential information about a Pennsylvania
College of Technology student. It is intended solely for the use of the
recipient. This email may contain information that is considered an
"educational record" subject to the protections of the Family Educational
Rights and Privacy Act Regulations. The regulations may be found at 34
C.F.R. Part 99 for your reference. The recipient may only use or disclose
the information in accordance with the requirements of the Federal
Educational Rights and Privacy Act Regulations. If you have received this
transmission in error, please notify the sender immediately and permanently
delete the email.
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD