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 |
|
stoneferry
Starting Member
3 Posts |
 Posted - 2008-07-30 : 03:34:36
|
| Or should I say just making sure all columns are created and proper. I have 6 databases I need to keep maintained to a same level, all standalone. What is the best way to keep the schemas up to date without resorting to manually updating...? Obviously I cannot use DROP table or CREATE table based scripts.Cheers |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-30 : 17:10:47
|
| Didn't really understand you question? You can see Schema change history in Standard reports that comes with SQL Server. Or you can script it. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-07-30 : 22:25:17
|
| Every time you make schema change, ensure you apply the change to all 6 dbs. |
|
|
|
|
|
|
Offsite Replication of Schema