Lesson 8: Synchronizing

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

In this lesson, you synchronize again with the schema changes.

 Synchronize
  • Synchronize again by running the following command:

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

    The row for Sue Slow that was inserted before the schema change is uploaded using the script version my_ver1. The row for Mo Hamid that was inserted after the schema change is uploaded using the script version my_ver2. Rows are downloaded using the download cursor for my_ver2.

    The schema change is now complete and you can continue synchronizing normally.