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.

Prerequisites

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 script version clause.

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

Task

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

INSERT INTO customer VALUES( 100, 'John Jones', '519-555-1234' );
COMMIT;

Using the instance of Interactive SQL that is connected to the remote database, execute the following SQL statement to insert a row in the customer table.

INSERT INTO customer VALUES( 1, 'Willie Lowman', '705-411-6372' );
COMMIT;

Synchronize by running the following command.

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

Results

The remote database is synchronized.

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.

Next

Proceed to Lesson 4: Inserting data in the remote database.

Discuss this page in DocCommentXchange.