Use the create subscription Command to Create a Publication Subscription

Use create subscription to create a publication subscription and an article subscription for each article in the publication.

You can use create subscription to materialize source data at the destination database using the atomic, nonatomic, or no-materialization method.

Execute create subscription at the Replication Server that manages the destination database. Subscription information is stored in the rs_subscriptions system tables at the primary and replicate sites.

This example creates a subscription named pubs2_sub for the publication pubs2_pub. It also creates a subscription named pubs2_sub for each article in pubs2_pub. The source database is pubs2 managed by the TOKYO_DS data server. The destination database is also named pubs2; it is managed by the SYDNEY_DS data server.

create subscription pubs2_sub 
		for publication
		with primary at TOKYO_DS.pubs2
		with replicate at SYDNEY_DS.pubs2

Note: The maximum size of a where clause in a create subscription statement is 255 characters.

See Replication Server Reference Manual > Replication Server Commands for complete syntax and usage guidelines.

Specify a Materialization Method for Publication Subsciptions
Specify materialization methods for publication subscriptions in the same way you specify materialization methods for regular subscriptions.
Refresh Publication Subscriptions
When you add articles to an existing publication, you must add article subscriptions to the existing publication subscription to subscribe to the new articles. Use for new articles to refresh the subscription.

Parent topic: Create Publication Subscriptions