Create Publication Subscriptions with Bulk Materialization

Bulk materialization allows you to load subscription data from media such as magnetic tape. Use this method if the amount of data to be transferred is too large to copy through the network.

You can also use this method to create subscriptions for function replication definitions.

When you create publication subscriptions with bulk materialization, you must use define subscription, activate subscription, and validate subscription. You use these bulk materialization commands to create publication subscriptions in the same way you create single subscriptions. You cannot include where clauses in publication subscriptions.

• Use the define subscription Command for Publication Subscriptions
  Use define subscription to create a publication subscription and a subscription for each article in the publication.
• Use the activate subscription Command for Publication Subscriptions
  Use activate subscription to activate a publication subscription and its subscription subset.
• Use the validate subscription Command for Publication Subscriptions
  Use validate subscription to set the subscription status to VALID for the publication subscription, and its subscription subset.
• Refresh 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.