Creating a remote database

Any SQL Anywhere database can be used as a remote database in a MobiLink system. All you need to do is create a publication, create a MobiLink user, create a synchronization subscription, and register the user with the consolidated database.

Note

A database that does not have a transaction log can only be used as a remote database for scripted upload and for download-only publications.

If you use the Create Synchronization Model Wizard to create your MobiLink client application, these objects are created for you when you deploy the model. Even then, you should understand the concepts.

 To use a SQL Anywhere database as a remote database

  1. Start with an existing SQL Anywhere database, or create a new one and add your tables.

  2. Create one or more publications in the remote database.

    See Publishing data.

  3. Create MobiLink users in the remote database.

    See Creating MobiLink users.

  4. Register users with the consolidated database.

    See Adding MobiLink user names to the consolidated database.

  5. Create synchronization subscriptions in the remote database.

    See Creating synchronization subscriptions.

Deploying remote databases
Setting remote IDs
Upgrading remote databases
Progress offsets

Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0