Microsoft® SQL Server 2012 Unleashed

Publications and Articles

A single database can contain more than one publication. You can publish data from tables, from database objects, from the execution of stored procedures, and even from schema objects, such as referential integrity constraints, clustered indexes, nonclustered indexes, user triggers, extended properties, and collation. Regardless of what you plan to replicate, all articles in a publication are synchronized at the same time. Figure 40.4 shows an example of a publication (named Cust_Orders publication) with three articles (three tables from the AdventureWorks2012 database). You can choose to replicate whole tables or just parts of tables via filtering.

FIGURE 40.4 The Cust_Orders publication (in the AdventureWorks2012 ...