Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
beahava
Starting Member
1 Post |
 Posted - 2005-07-13 : 08:13:55
|
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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
Update Automations