Contents Index Add a SQL Remote message type Add publications and subscriptions

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 the publisher and remote user to the database

In SQL Remote's hierarchical replication system, each database may have zero or one database immediately above it (the consolidated database) and zero or more databases immediately below it (remote databases).

In this tutorial, the current database is the consolidated database of a two-level system. It has no database above it, and only one remote database below it.

The following diagram illustrates the two databases:

For any database in a SQL Remote replication setup, there are three permissions that may be granted to identify databases on the hierarchy:

Permissions can only be granted by a user with DBA authority. To carry out these examples you should connect from Sybase Central to the hq database as user ID DBA, with password SQL.

Add a database publisher user ID 

Any database, consolidated or remote, that distributes changes to other databases in the replication system is a publisher database. Each database in the replication system is identified by a single user ID. You set that ID for your database by adding a publisher to the database. This section describes setting permissions for the consolidated hq database.

First create a user ID named hq_user, who will be the publisher user ID.

To create a new user as the publisher

  1. Select the Users & Groups folder.

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

    The User Creation wizard appears.

  3. Enter the name hq_user, with password hq_pwd, and click Finish.

  4. Right-click the hq_user icon and choose Change to Publisher from the popup menu.

    A database can have only one publisher. You can find out who the publisher is at any time by opening the Users & Groups folder.

Add a remote user 

Each remote database is identified in the consolidated database by a user ID with REMOTE permissions. Whether the remote database is a personal database server or a network server with many users, it needs a single user ID to represent it to the consolidated database.

In a mobile workgroup setting, remote users may already be users of the consolidated database, and so no new users would need to be added; although they would need to be set as remote users.

When a remote user is added to a database, the message system they use and their address under that message system need to be stored along with their database user ID.

To add a remote user

  1. Select the SQL Remote Users folder.

  2. From the File menu, choose New > SQL Remote User.

    The Create a New Remote User wizard appears.

  3. Create a remote user with user ID field_user with the following options:

  4. When you have finished, click Finish to create the remote user.

    You have now created the users who will use this system.


Contents Index Add a SQL Remote message type Add publications and subscriptions