Publications

Use publications to collect replication definitions for tables and/or stored procedures and then subscribe to them as a group.

With publications, you can monitor the status of one publication subscription for a set of tables and procedures. Publication usage is not a separate model; it provides a grouping technique that can be used by any model.

When you use publications, you create and manage the following objects:

The following steps summarize the procedure for replicating data using publications.

At the primary site:

  1. Create or select the replication definitions to include in the publication.

  2. Create the publication, using the create publication command.

  3. Create articles that reference the replication definitions you have chosen, using the create article command.

  4. Validate the publication using the validate publication command.

At the replicate site:

Create a subscription for the publication using the create subscription command.

In Figure 3-11, a table replication definition pubs_rep, referenced by two articles, and a function replication definition, referenced by one article, are collected in the publication pubs2_pub.

Figure 3-11: Publications

In Figure 3-11, a table replication definition called pubs underscore rep, referenced by two articles, and a function replication definition, referenced by one article, is collected in the publication called pubs 2 underscore pub.