Refreshing publication subscriptions using bulk materialization

When you refresh a publication subscription using bulk materialization, use the for new articles clause when you define the publication subscription. You do not need to repeat the clause when you activate and validate the subscription.

The following example refreshes the publication subscription pubs2_sub.

define subscription pubs2_sub 
    for publication pubs2_pub
    with primary at TOKYO_DS.pubs2
    with replicate at SYDNEY_DS.pubs2
    for new articles

See “define subscription” in the Replication Server Reference Manual for syntax and usage guidelines.

To check whether a subscription exists for each article in a publication, execute check subscription at the primary or replicate Replication Server. See “Display status information” for more information about check subscription.