Automation of SQL updates

Question

Post reply

Automation of SQL updates

Sarah Illouz

SSC Enthusiast

Points: 107
More actions
July 13, 2005 at 5:51 am

#165383

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
4. To see that it works, generate

THANKS GUYS!!!!
TAKE CARE!
Sarah

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

AJ Ahrens SSC-Insane Points: 20676 More actions · Answer 1

I would look at Red Gates SQL Compare

Good Hunting!

AJ Ahrens

webmaster@kritter.net

Ray M SSC-Insane Points: 21093 More actions · Answer 2

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

rschaeferhig SSCrazy Eights Points: 8776 More actions · Answer 3

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.