In order to set up a system according to the basic primary copy model, you need to:
Set up routes and connections between Replication Servers.
For information on these topics, see Chapter 6, “Managing Routes” and Chapter 7, “Managing Database Connections.”
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.
For information on setting permissions for a Replication Server system, see Chapter 8, “Managing Replication Server Security.”
Allow replication on the tables using the sp_setreptable system procedure.
Create a replication definition for the table at the primary site.
For information about creating replication definitions, see Chapter 9, “Managing Replicated Tables.”
At each site, create a subscription for the table replication definition at the primary site.
For information about creating subscriptions, see Chapter 11, “Managing Subscriptions.”
