Lesson 3: Synchronize 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.

 To synchronize the remote database
  1. Using the instance of Interactive SQL that's connected to the consolidated database, execute the following SQL 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's connected to the remote database, execute the following SQL to insert a row in the customer table.

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

    dbmlsync -v+ -ot sync1.txt -c uid=dba;pwd=sql;eng=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 dbmlync log, sync1.txt and check for errors.