Contents Index Add a SQL Remote message type Add a remote user to the database

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

Add the publisher to the database


Each database in a SQL Remote replication system needs a single user ID that identifies the publisher of the data. Here, we make the DBA user ID the publisher.

Set the publisher

  1. Click the Users & Groups folder in the left pane.

  2. Right-click DBA in the right pane, and choose Change to Publisher from the popup menu.

    Publisher appears in the Type column beside DBA.

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


Contents Index Add a SQL Remote message type Add a remote user to the database