Lesson 8: Synchronizing

This lesson assumes you have completed all preceding lessons. See Lesson 1: Setting up a MobiLink consolidated database.

In this lesson, you synchronize the remote databases with the consolidated database using the dbmlsync utility on a MobiLink client to connect to the MobiLink server.

 Start the synchronization clients

  1. At a command prompt, change to the c:\MLintro\mlintro_project\sync_mlintro\remote directory.

  2. Run the following command to synchronize the sync_mlintro_remote database: 

    dbmlsync -c "SERVER=sync_mlintro_remote;UID=DBA;PWD=sql" -o rem1.dbs -v+

    A window appears displaying all information relevant to the sync_mlintro_remote client synchronization with the consolidated database. The information is saved to the rem1.dbs file, which is accessible after you close the client synchronization window.

    The following table contains a description for each dbmlsync utility option:

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

  3. Close the client synchronization window.

    Click Shut Down.

  4. Run the following command to synchronize the sync_mlintro_remote2 database: 

    dbmlsync -c "SERVER=sync_mlintro_remote2;UID=DBA;PWD=sql" -o rem2.dbs -v+

    A window appears displaying all information relevant to the sync_mlintro_remote2 client synchronization with the consolidated database. The information is saved to the rem2.dbs file, which is accessible after you close the client synchronization window.

  5. Close the client synchronization window.

    Click Shut Down.

  6. Pause chart scrolling.

    Click Monitor » Pause Chart Scrolling.

  7. In the MobiLink Monitor, use the bottom pane to scroll back to the last synchronization.

  8. Look at the properties of the last synchronization.

    Double-click the vertical colored bar to view the synchronization properties.

  9. Proceed to Lesson 9: Using the MobiLink Server Log File Viewer to check for errors and warnings.

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1