Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote
    Lesson 4: Replicate data

Replicate from the remote database to the consolidated database

Now try entering data at the remote database and sending it to the consolidated database. Only the outlines are presented here.

Replicate data from the remote database to the consolidated database

1. Insert a row at the remote database, for a department with a dept_id of 203 and a dept_name of Western Sales.

2. Run dbremote to send the message to the consolidated database:

   dbremote -c "dbn=field;uid=field;pwd=field"

3. Run dbremote to receive the message at the consolidated database:

   dbremote -c "dbn=asademo;uid=DBA;pwd=SQL"

4. Display the data in the department table at the consolidated database: It contains the Western Sales row.

What next? 

The tutorial is now complete, but you should continue to the next section to restore the sample database to its original form.