SQL Remote User's Guide
  A Tutorial for Adaptive Server Enterprise Users
    Start replicating data

Send data from the consolidated database

To send the rows to the remote database, you must run the Message Agent at the consolidated database. The ssremote program is the Message Agent for Adaptive Server Enterprise.

To replicate the data from Adaptive Server Enterprise

1. Enter the following statement (on a single line) at the command line to run the Message Agent against the consolidated database:

   ssremote -c "eng=server-name;dbn=hq;uid=sa;pwd=sysadmin"

2. Click Shutdown on the Message Agent window to stop the Message Agent when the messages have been sent.