Set Up a Primary Copy Model System

You need to create and configure several replication system components to set up a replication system according to the basic primary copy model.

  • Set up routes and connections between Replication Servers.

  • Create the table in the primary and replicate databases. The table should have the same structure in each database.

  • Create indexes and grant appropriate permissions on the tables.

  • Allow replication on the tables using the sp_setreptable system procedure.

  • Create a replication definition for the table at the primary site.

  • At each site, create a subscription for the table replication definition at the primary site.

Related concepts
Manage Routes
Manage Database Connections
Manage Replication Server Security
Manage Replicated Tables
Manage Subscriptions