Re: replicate DB2 table to MS SQL

[Alan Campin <alan0307d@xxxxxxxxx>]

Sure, look at Scott Klement's JDBC4 product. Free. Lets you run SQL
statements from the IBM i and execute on the Sequel database.


On Mon, Nov 20, 2017 at 5:46 PM, Mike Cunningham <mike.cunningham@xxxxxxx>
wrote:

> 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