Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 17 » SQL Anywhere Server - Database Administration » Database configuration » Database options » Alphabetical list of database options

ml_remote_id option [MobiLink]

Sets the remote ID for a remote database in a MobiLink synchronization system.

Allowed values

Any value that uniquely identifies the database for MobiLink synchronization.

Default

Empty string

Scope
  PUBLIC role For current user For other users
Allowed to set permanently? Yes, with SET ANY USER DEFINED OPTION Yes Yes, with SET ANY USER DEFINED OPTION
Allowed to set temporarily? No No No
Remarks

MobiLink synchronization uses the PUBLIC role setting only.

This option assigns a remote ID for a remote database in a MobiLink synchronization system. The remote ID must be unique within your synchronization system.

If you set the remote ID manually and you subsequently recreate the remote database, you must either give the recreated remote database a different name from the old one or use the ml_reset_sync_state stored procedure to reset the state information in the consolidated database for the remote database.

Caution

The safest time to change the remote ID is before the first synchronization. If you change it later, be sure you have performed a complete, successful synchronization just before changing the remote ID. Otherwise you may lose data and put your database into an inconsistent state.

Example

The following SQL statement sets the remote ID to the value HR001:

SET OPTION PUBLIC.ml_remote_id = 'HR001'