Have you already had a look at the GENERATE_SQL Stored Procedure
https://www.ibm.com/support/knowledgecenter/ssw_ibm_i_73/rzajq/rzajqprocgens
ql.htm?
This procedure will generate the SQL Code for creating any database object.
Mit freundlichen Grüßen / Best regards
Birgitta Hauser
"Shoot for the moon, even if you miss, you'll land among the stars." (Les
Brown)
"If you think education is expensive, try ignorance." (Derek Bok)
"What is worse than training your staff and losing them? Not training them
and keeping them!"
?Train people well enough so they can leave, treat them well enough so they
don't want to.? (Richard Branson)
-----Original Message-----
From: MIDRANGE-L [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike
Cunningham
Sent: Dienstag, 21. November 2017 02:46
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
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
________________________________
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
midrange.com
