SQL Remote User's Guide
  Tutorials for Adaptive Server Anywhere Users
    Tutorial: Adaptive Server Anywhere replication using Sybase Central
      Setting up a 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 SalesRep and some of the rows of the Customer table.

To add a publication

1. Select the Publications folder in the left pane.

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

   The Publication Creation wizard appears.

3. Name the publication SalesRepData.

4. On the Tables tab, select SalesRep from the list of Available Tables. Click Add.

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

5. Select Customer from the list of Available Tables. Click Add.

6. On the SUBSCRIBE BY Restrictions tab, select the Customer table and enter the expression rep_key.

7. 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 SalesRepData publication for the remote database user field_user.

To add a subscription

1. Open the Publications folder and select the SalesRepData publication in the left pane.

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

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

   The SQL Remote Subscription Creation wizard appears.

4. Choose to subscribe field_user. Enter a Subscription value of rep1 and click Finish.

   The subscription value is an expression that matches the Subscribe By expression in the publication. In a later step, the field_user user ID is assigned a rep_key value of rep1.

You have now set up the consolidated database.