Configuring RepAgent Using Command Line Options

There are several basic steps for configuring RepAgent from the command line.

1. Define the local Adaptive Server using sp_addserver.
2. Enable the RepAgent feature on Adaptive Server using sp_configure.
3. Enable the RepAgent feature for each database using sp_start_rep_agent.
4. Enable log transfer on Replication Server using alter connection.
5. Start the RepAgent on Adaptive Server using sp_start_rep_agent.

• Define the Local Adaptive Server
  If you are starting Adaptive Server for the first time, you must execute the Adaptive Server system procedure sp_addserver to add an entry for the local server to the Adaptive Server sysservers table.
• Enabling RepAgent on Adaptive Server
  Use sp_configure to enable RepAgent on Adaptive Server.
• Enabling RepAgent at the Primary Database
  Execute sp_config_rep_agent to enable the RepAgent for each primary database and set default values for RepAgent configuration parameters.
• Enabling Log Transfer for the Primary Database
  Use set log transfer on to enable log transfer for each connection between Replication Server and a primary database.