Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote
    Lesson 3: Set up the remote database

Verify that the database is created properly

To see what the extraction utility has done, connect to the field database and confirm that all the database objects are created.

Browse through the remote database

1. In Sybase Central, click the Connect button.

   The Connect dialog appears.

2. On the Identification tab, enter the user ID field and password field.

3. On the Database tab, enter the database path (for example, c:\tutorial\field.db). Click OK to connect to the database.

   The database field appears in the left pane of Sybase Central.

4. Open the Tables folder. The department table, owned by user DBA, is in the list.

5. In the left pane, click the Department table. In the right pane, click the Data tab to show the five rows of the department table.

6. Open the SQL Remote Users folder. The field user appears in the right pane, showing that field is the publisher for this database. Any data sent from this database comes from the user field, just as any data from the consolidated database comes from the user DBA.

   You will see that user ID DBA is present, and is designated as a consolidated user. This means DBA is the publisher of the consolidated database (above the field database in the hierarchy).

7. Open the Publications folder. You will see that the DepartmentPub publication is present.

What next? 

The system is now ready for replication.

Leave Sybase Central open for use later in the tutorial.