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

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.

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