Show TOC

Publication Subscription CommandsLocate this document in the navigation structure

Publication subscriptions use the same commands as subscriptions for replication definitions.

  • To create a publication subscription using atomic materialization, nonatomic materialization, or nonmaterialization, use create subscription.

  • To create a publication subscription using bulk materialization, use define subscription and the other bulk materialization commands.

When you add an article to a publication that has a subscription, you must refresh the publication subscription to include subscriptions for the new article. This process is called rematerialization.
  • For atomic or nonatomic rematerialization, use create subscription with the for new articles clause.

  • If data is in sync at the primary and replicate databases, use create subscription with the for new articles clause and the without materialization keywords.

  • For bulk rematerialization, use define subscription with the for new articles clause, then use the other bulk materialization commands.