October 17, 2006 at 6:06 pm
The scripts that "generate SQL script" creates are just scripts to reverse engineer the structure(s) you created. What I really need is a script to dynamically re-create the replication based on values and/or parameters. Ideally, some sort of "wild-card" definition of the articles to be included. Nobody here wants to manually edit a script to add a table or column to the article, or create a new article. We want to do a "diff" report (which I can handle) and based on changes, automatically create new scripts that can be automatically run to re-create the snapshot without intervention.
What am I missing?
Thank-you,
David Russell
Any Cloud, Any Database, Oracle since 1982
October 17, 2006 at 6:27 pm
Dave, I think this is wishful thinking. There are many tools out there that can deal with database schema differences, but not to script out the changes as replication DML commands, which I take is what you were after.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply