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

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Changing a schema using the ScriptVersion extended option

 

Lesson 3: Synchronizing the remote database

You should now have a working synchronization system set up. In this lesson, you test it by inserting some data and synchronizing.

Prérequis

This lesson assumes you have the roles and privileges listed in the Privileges section at the start of this tutorial: Tutorial: Changing a schema using the ScriptVersion extended option.

This lesson assumes you have completed all preceding lessons. See Lesson 1: Creating and configuring the consolidated database.

 Task
  1. Using the instance of Interactive SQL that is connected to the consolidated database, execute the following SQL statements to insert a row in the customer table.

    INSERT INTO customer VALUES( 100, 'John Jones', '519-555-1234' );
    COMMIT;
  2. Using the instance of Interactive SQL that is connected to the remote database, execute the following SQL statements to insert a row in the customer table.

    INSERT INTO customer VALUES( 1, 'Willie Lowman', '705-411-6372' );
    COMMIT;
  3. Synchronize by running the following command.

    dbmlsync -v+ -ot sync1.txt -c UID=DBA;PWD=sql;SERVER=remote -s my_sub -k

    You can confirm that the synchronization succeeded by comparing the contents of the customer table in the remote and consolidated databases. You might also want to look at the dbmlsync log, sync1.txt and check for errors.

Résultat

The consolidated and remote databases are synchronized.