Subscriptions

A subscription is created on the replicate database to subscribe to a specific replication definition. It identifies the primary database, which contains the data to be replicated.

You can create a subscription for any type of replication definition: databases, tables, and stored procedures.

StepsCreating a subscription for a database replication definition

  1. In the object tree, double-click the database where you want to create a subscription.

  2. Double-click the Database Subscriptions folder.

  3. In the Details pane, double-click the Add Subscription icon.

  4. Enter the name of the subscription.

  5. Under Primary, select the Connection and the database replication definition that you want to subscribe to.

  6. Select a materialization method from the drop-down list (optional).

  7. Specify whether to Subscribe to truncate table (optional).

  8. Click OK.