2

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.

arena-ru
  • 990
  • 2
  • 12
  • 25

1 Answers1

3

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.

Damien_The_Unbeliever
  • 234,701
  • 27
  • 340
  • 448