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 |
|
jung1975
Aged Yak Warrior
503 Posts |
 Posted - 2004-08-10 : 15:23:24
|
| Which replication is best for updating the schema changes (change constraints, new tables, drop constraints)?For example,Server A , Server B I want to set up the replication between server A and server B so that the server B can be updated constantly whenever there is schema changes in server A |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-10 : 15:24:50
|
| Replication handles data, not schema changes. You should script out your changes then run them on the other server. If you make your changes in Enterprise Manager, you can click the save change script button to save the script to a file. Log shipping would move the schema changes, but you wouldn't be able to use ServerB except for read-only purposes if you used log shipping.Tara |
 |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2004-08-12 : 03:01:34
|
| just a wild idea.will it be possible to backup master and msdb databases from serverA then restore on serverB? You can schedule the backup and restore and check if the backup is 'new' |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-12 : 11:51:28
|
| How does that help with schema changes?Tara |
|
|
|
|
|
|
Replication for updating schema