Alter Tables that are replicated in SQL Server 2008 R2

18,856

The article "Making Schema Changes on Publication Databases" should cover most of what you need to know. Unlike older versions of SQL Server, you should just be able to make the DDL changes (assuming you haven't unset the replication defaults).

As the article mentions, you won't be able to use SSMS to make these changes.

Share:
18,856
arena-ru
Author by

arena-ru

Updated on June 04, 2022

Comments

  • arena-ru
    arena-ru almost 2 years

    We have two databases and some tables in them are replicated.
    We want to add to table new rows and also include them in replication.
    How can we do this?

    Example:
    We have [dbo1].Table1 and [dbo2].Table2 that are replicated with all columns and have identically structure.
    We want to add new column Column1 to both of the tables and include this column to replication.