Connectivity requirements for SQL Replication
Any workstation that runs the Apply program, the Replication Center,
or the replication commands must be able to connect to the source server,
Capture control server, Apply control server, and target server databases.
Creating control tables for SQL Replication
The replication programs use control tables to store information
about registered tables, subscription sets, operational parameters,
and user preferences. You create control tables before defining your
sources and targets for replication.
Setting up the replication programs
Before you can replicate, you need to set up the Capture program,
Apply program, and other replication programs for the servers in your environment.