Creating synchronization subscriptions

After creating MobiLink users and publications, you must subscribe at least one MobiLink user to one or more pre-existing publications. You do this by creating synchronization subscriptions.

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

Note

You must ensure that all subscriptions for a MobiLink user are synchronized to only one consolidated database. Otherwise, you may experience data loss and unpredictable behavior.

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

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

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

See CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink].

Example

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

  1. First, publish the customer and sales_order tables. Give the publication the name testpub.

    CREATE PUBLICATION testpub
 (TABLE customer, TABLE sales_order)

  2. Next, create a MobiLink user. In this case, the MobiLink user is demo_ml_user.

    CREATE SYNCHRONIZATION USER demo_ml_user

  3. To complete the process, create a subscription that links the user and 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

Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1