Lesson 7: Synchronize

Now you are ready to synchronize the remote client for the first time. This is done with the MobiLink client program dbmlsync. Dbmlsync connects to the remote database, authenticates itself with the MobiLink server, and performs all the uploads and downloads necessary to synchronize the remote and consolidated databases based on a publication in the remote database.

 To synchronize the remote client
  • At a command prompt, run the following command, all on one line:

    dbmlsync -c "server=remote_eng;dbn=remote_db;uid=DBA;pwd=sql;"
        -n sync_ase_publication
        -u ase_remote -mp ase_pass
    • dbmlsync   is the synchronization application.

    • server=remote_eng   specifies the name of the remote database server.

    • dbn=remote_db   specifies the name of the remote database.

    • uid   is the user name used to connect to the remote database.

    • pwd   is the password used to connect to the remote database.

    • sync_ase_publication   is the name of the publication on the remote device that is used to perform the synchronization. (This publication was created by the Create Synchronization Model Wizard.)

    • ase_remote   is the user name used to authenticate with the MobiLink server.

    • ase_pass   is the password used to authenticate with the MobiLink server.

    The progress of the synchronization is displayed in the SQL Anywhere MobiLink Client Messages window. When this command runs successfully, the dbmlsync application populates the remote database with a subset of information from the consolidated database.

    If synchronization fails, check the connection information you pass to the dbmlsync application, and the MobiLink user name and password. If the problem persists, check the publication name you used, and ensure the consolidated database and MobiLink server are running. You can also examine the contents of the synchronization logs (server and client).

    Note

    If you are running the dbmlsync application on a different computer from your MobiLink server, you must also pass in arguments that specify the location of the MobiLink server.

 View the data
 Further reading