Subscribing MobiLink synchronization users

MobiLink Synchronization User's Guide
Adaptive Server Anywhere Clients

Subscribing MobiLink synchronization users

To complete the setup, you must subscribe at least one MobiLink user to one or more pre-existing publications.

For information about creating publications, see Publishing data. For information about creating MobiLink users, see Creating MobiLink users.

Subscriptions versus synchronization subscriptions

Do not confuse subscriptions (CREATE SUBSCRIPTION statement) with synchronization subscriptions (CREATE SYNCHRONIZATION SUBSCRIPTION statement). Subscriptions work only with SQL Remote. They create relationships between publications and database users who have been granted remote privileges. Synchronization subscriptions, used with MobiLink, create relationships between publications and MobiLink users .

A synchronization subscription links a particular MobiLink user with a publication. It can also carry other information needed for synchronization. For example, you can specify the address of the MobiLink server and any desired options for a synchronization subscription. Values for a specific synchronization subscription override those set for MobiLink users.

Synchronization subscriptions are required only in MobiLink Adaptive Server Anywhere remote databases. Server logic is implemented through synchronization scripts, stored in the MobiLink system tables in the consolidated database.

A single Adaptive Server Anywhere database can synchronize with more than one MobiLink synchronization server. To allow synchronization with multiple servers, create different MobiLink users for each server.

Example

To synchronize the customer and sales_order tables in the Adaptive Server Anywhere sample database, you could use the following statements.

First, publish the customer and sales_order tables. Give the publication the name testpub.
```
CREATE PUBLICATION testpub
   (TABLE customer, TABLE sales_order)
```
Next, create a MobiLink user. In this case, the MobiLink user is demo_ml_user.
```
CREATE SYNCHRONIZATION USER demo_ml_user
```

To complete the process, subscribe the user to the publication.

CREATE SYNCHRONIZATION SUBSCRIPTION TO testpub
   FOR demo_ml_user
   TYPE tcpip
   ADDRESS 'host=localhost;port=2439;'
   OPTION sv='version1'

Altering MobiLink subscriptions
Dropping MobiLink subscriptions