Creating remote databases
Any SQL Anywhere database can be converted for use as a remote
database in a MobiLink installation. You can also create a new SQL
Anywhere remote database that uses all or part of the schema of the
consolidated SQL Anywhere database.
You create the database on your desktop using the SQL Central SQL
Anywhere plug-in, the Create SA Database utility in the Database painter,
or another tool. If your database uses an English character set, use the
1252 Latin1 collation sequence.
To use a database as a remote database for MobiLink synchronization,
you need to create at least one publication and MobiLink user, then add a
subscription to the publication for the user. See Creating and modifying publications, Creating MobiLink users, and Adding subscriptions.
Remote database schemas
Tables in a remote database need not be identical to those in the
consolidated database, but you can often simplify your design by using a
table structure in the remote database that is a subset of the one in the
consolidated database. Using this method ensures that every table in the
remote database exists in the consolidated database. Corresponding tables
have the same structure and foreign key relationships as those in the
consolidated database.
Tables in the consolidated database frequently contain extra columns
that are not synchronized. Extra columns can even aid synchronization. For
example, a timestamp column can identify new or updated rows in the
consolidated database. In other cases, extra columns or tables in the
consolidated database might hold information that is not required at
remote sites.