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 Sybase Central SQL Anywhere plug-in, the Create
ASA 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.