Automation of SQL updates
-
I am trying to contruct a tool for the automation of database updates.
I was wondering if you guys knew of such a tool that was on the market already or that you produced that I can get familiar with...
We have a client's database, and a database here s is basically the updated version of the client database.
Basically, I would like to construct a tool that will convert the updated database into a script file( I know how to do that), then compare both the scripts from the client's database and the updated database and generate the differences and scripts . These scripts will then be scripted into the clients database for them to become identical databases.
Here it the outline of the tool...
1- Indentify the differences between the databases
à create a script file for both databases
à run both files into the exam differences tool
à recognize the differences
2. For each difference, generate the SQL code for it
à For difference x, code y
3. Run each difference into the update script
THANKS GUYS!!!!
TAKE CARE!
Sarah
-
I would look at Red Gates SQL Compare
Good Hunting!AJ Ahrens
webmaster@kritter.net -
Sql Compare will clearly show differences, But I can't remember if it produces anything you could use to programatically create a script so you can update the different database. But Sql Complare is a great place to start
-
If you use SQL Compare in concert with SQL Packager you can create "batch" jobs that will create the script and apply it against the target database automatically.
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply