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.