Export (0) Print
Expand All
Expand Minimize
This topic has not yet been rated - Rate this topic

How to: Replicate Schema Changes (SQL Server Management Studio)

By default, the following schema changes made at a Publisher running SQL Server are replicated to all SQL Server Subscribers:

  • ALTER TABLE

  • ALTER VIEW

  • ALTER PROCEDURE

  • ALTER FUNCTION

  • ALTER TRIGGER

If you do not want to replicate schema changes for a publication, disable the replication of schema changes in the Publication Properties - <Publication> dialog box. For more information about accessing this dialog box, see How to: View and Modify Publication and Article Properties (SQL Server Management Studio).

NoteNote

The ALTER TABLE … DROP COLUMN command is always replicated to all Subscribers whose subscription contains the columns being dropped, even if you disable the replication of schema changes.

To disable replication of schema changes

  1. On the Subscription Options page of the Publication Properties - <Publication> dialog box, set the value of the Replicate schema changes property to False.

  2. Click OK.

    To propagate only specific schema changes, set the property to True before a schema change, and then set it to False after the change is made. Conversely, to propagate most schema changes, but not a given change, set the property to False before the schema change, and then set it to True after the change is made.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.