Alter Tables that are replicated in SQL Server 2008 R2

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开发者_StackOverflow中文版 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.

---

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.