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 |
|
cidr
Posting Yak Master
207 Posts |
 Posted - 2010-01-08 : 06:20:59
|
| Hi there,Where I work we have a replicated database. There has been schema changes to the primary database. For example, there has been a column added to one of the tables.I need to apply the changes to the replicated database. How can this be done? and without downtime if possible?Thanks for help in advance |
|
|
dinakar
Master Smack Fu Yak Hacker
2507 Posts |
Posted - 2010-01-08 : 16:09:00
|
| If its SQL 2000, it wouldnt have let you change the schema if the table was being published. you need to use the special replication stored procedures - sp_repladdcolumn/sp_Repldropcolumn to add/drop columns to tables that are being published, so the schema changes are replicated on the subscribers. From SQL 2005 onwards, there have been improvements in this area and you can directly change the schema with ALTER TABLE and the changes are replicated automatically for you.Dinakar Nethi************************Life is short. Enjoy it.************************http://weblogs.sqlteam.com/dinakar/ |
 |
|
|
|
|
|
schema changes for replicated db