Introducing SQL Anywhere Studio
  Tutorial: Replicating Data with SQL Remote
    Lesson 2: Set up the consolidated database

Add publications and subscriptions

This section describes how to add a publication to a database, and how to add a subscription to that publication for a user. The publication replicates all rows of the table department.

Add a publication

1. Open the Publications folder.

2. From the File menu, choose New > Publication.

   The Publication Creation wizard appears.

3. Name the publication DepartmentPub on the first page of the wizard. Click Next.

4. Select department from the list of Available Tables. Click Add.

   The table appears in the list of Selected Tables on the right.

5. Click Finish to create the publication.

Add a subscription 

Each user ID that is to receive changes to a publication must have a subscription to that publication. Subscriptions can only be created for a valid remote user. You need to add a subscription to the DepartmentPub publication for the remote database user field.

Add a subscription

1. Open the Publications folder.

2. Click the SQL Remote Subscriptions tab in the right pane.

3. From the File menu, choose New > SQL Remote Subscription.

   The Create SQL Remote Subscription for Remote User dialog appears.

4. Choose to create a submscription for the user field. Click Next

5. Click Finish.

You have now set up the consolidated database.

What next? 

You can now create the remote database.