Lesson 5: Synchronize

The dbmlsync utility initiates MobiLink synchronization for SQL Anywhere remote databases.

 To start the synchronization clients
  1. Run the following command to synchronize the remote1 database:

    dbmlsync -c "server=remote1;uid=DBA;pwd=sql" -o rem1.txt -v+
  2. Run the following command to synchronize the remote2 database:

    dbmlsync -c "server=remote2;uid=DBA;pwd=sql" -o rem2.txt -v+

The following table contains a description for each dbmlsync option used in this lesson:

Option Description
-c Specifies the connection string.
-o Specifies the message log file.
-v+ The -v option specifies what information is logged. Using -v+ sets maximum verbose logging.

An output screen appears indicating that the synchronization succeeded. SQL-based synchronization transferred rows in the client Product table to the Product table in the consolidated database.

 Further reading