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 |
|
spinal007
Starting Member
7 Posts |
 Posted - 2005-07-25 : 08:45:02
|
| The problem: I need to synchronize 2 (or more) databses which are still in the development stage, but I can't see an easy way to keep the existing data and update only the structure of the database.I'm very familiar with generating SQL scripts and that's what I've been doing so far. That is fine for installing the databases but the data is lost everytime (because tables are dropped and re-created).Is there a way that I can update changes made without loosing any information other than: 1. renaming existing tables 2. then creating new ones 3. then copying the existing data onto new tables 4. then deleting old tablesIdeally, is there a tool that will compare 2 databases and script the differences for me?Help is very much appreciated. |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
spinal007
Starting Member
7 Posts |
Posted - 2005-07-25 : 10:26:06
|
| thanks, I've actually found a few of those comparison tools so I'll try them out. |
 |
|
|
|
|
|
change scripts