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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-01-31 : 09:02:55
|
| ak writes "After setting up a continuous processing(transactional) replication, if we need to make any changes in the table structure, do we have to disable/drop the replication and have to redesign/reset again the replications once we finished the changes in the table?In this case, wont it increase the workload of the DBA? How can we overcome this?"" |
|
|
mblythe
Starting Member
16 Posts |
Posted - 2006-01-31 : 12:42:59
|
| In SQL Server 2000, you can add and drop columns from replicated tables using sp_repladdcolumn and sp_repldropcolumn. Other schema changes require reconfiguration. In SQL Server 2005, we support common schema changes directly using ALTER TABLE, etc.Michael Blythe Technical WriterSQL Server Replication - Microsoft --------------------------------------------------------------------------- This posting is provided "AS IS" with no warranties, and confers no rights. |
 |
|
|
|
|
|
Creating Replications