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 |
|
fqiao70
Yak Posting Veteran
52 Posts |
 Posted - 2005-08-30 : 12:36:56
|
| Hi, I have two databases, one production and one test. I don't want to restore the whole test database from production then my new tables and procedures of test will be gone? I just want to apply the table changes of production into test and keep them in sync. How could I do that????? THank you very much! |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-08-30 : 12:41:18
|
| If you perform a restore, then yes all of your new stuff will be gone in the test database. I use a third party tool called SQL Compare by Red Gate to check the diffs between two databases. It'll even generate the scripts for you. But why does production have changes that your test database never got? This should never happen.Tara |
 |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-31 : 00:01:34
|
| We script all the changes we make, then we can apply them, in order, to any database that needs to be patched "up to date"Enterprise Manager's "Design Table" has a button to generate a script of the change you are making (and even a checkbox to always generate a script, just in case you forget to press the button one day!)Kristen |
|
|
|
|
|
|
restoring a database