With publication subscriptions, you create subscriptions for a group of replication definitions using a single command. You collect replication definitions and their articles in a publication at the primary Replication Server. At the replicate Replication Server, you create a publication subscription against that publication.
When you create a publication subscription, Replication Server creates a subscription for each article in the publication.
Publication subscriptions and article subscriptions follow the rules and requirements for single subscriptions with one exception: They cannot contain where clauses. To specify a subset of rows that the replicate Replication Server receives, include where clauses in the article. Refer to “Specifying a where clause with the create article command” for more information.
To use publications, the primary Replication Server must be version 11.5 or later. To use publication subscriptions, the replicate Replication Server and the route from the primary Replication Server and the replicate Replication Server must be version 11.5 or later.
The following restrictions apply:
A valid publication must exist before you can create a publication subscription against it.
The name of a publication subscription must be unique to the publication, to the destination data server, and to the destination database.
You can include articles in one or more publications that reference different replication definitions for the same primary table. However, you cannot subscribe to more than one replication definition per primary table for each replicate table.
Use the command line to create and manage publication subscriptions.
Refer to “Using publications to replicate data at the command line” for a list of steps for creating publications and publication subscriptions.
Refer to “Using publications” for an overview of creating publications and publication subscriptions.