Contents Index Send data from the consolidated database Replicate from the remote database to the consolidated database

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

Receive data at the remote database


To receive the insert statement at the remote database, you must run the Message Agent, dbremote, at the remote database.

To receive the data at Adaptive Server Anywhere

  1. With the database server running, receive the data using the Message Agent for Adaptive Server Anywhere:

    dbremote -c "eng=field;dbn=field;uid=DBA;pwd=SQL"

    For more information on dbremote options, see The Message Agent.

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

The Message Agent window displays status information while running. This information can be output to a log file for record keeping in a production setup.

The Message Agent first receives a message from hq, and then sends a message. This return message contains confirmation of successful receipt of the replication update; such confirmations are part of the SQL Remote message tracking system that ensures message delivery even in the event of message system errors.

Verify that the data has arrived 

You should now connect to the remote field database using Interactive SQL, and inspect the SalesRep and Customer tables, to see which rows have been received.

To verify that the data has arrived

  1. Connect to the field database using Interactive SQL.

  2. Inspect the SalesRep table by typing the following statement:

    SELECT * FROM SalesRep

    You will see that the SalesRep table contains both rows entered at the consolidated database. This is because the SalesRepData publication included all the data from the SalesRep table.

  3. Inspect the Customer table by typing the following statement:

    SELECT * FROM Customer

    You will see that the Customer table contains only one row (Ocean Sports) entered at the consolidated database. This is because the SalesRepData publication included only those customers assigned to the subscribed Sales Rep.


Contents Index Send data from the consolidated database Replicate from the remote database to the consolidated database