UltraLite ml_remote

UltraLite ml_remote_id option

The remote ID is a unique identifier for an UltraLite database that is used by MobiLink to identify the database for synchronization. The remote ID can be any string that has meaning to you, as long as the string remains unique among all remote MobiLink clients. The ID can also be set to NULL (NULL is the initial value). During synchronization, if the remote ID is NULL, UltraLite will assign it to a generated GUID.

If you prepopulate an UltraLite database using synchronization for distribution to multiple devices, you must reset the remote ID to NULL before distribution to ensure that each database has a unique remote ID. Upon distribution, a new unique remote ID can be set explicitly or it can be left as NULL so that UltraLite will automatically generate a new unique value.

Allowed values

Default

Remarks

MobiLink uses the remote ID to store the synchronization information for the remote database. Given the remote ID, MobiLink user names are no longer required to be unique. The remote ID becomes particularly useful when you have multiple MobiLink users synchronizing the same UltraLite database. In this case, your synchronization scripts should reference the remote ID and not just the user name.

When this option is set, UltraLite performs a commit.

To set the ml_remote_id option from a client application, set it using the set database option function for the programming interface you are using or use the SET OPTION SQL statement.