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 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.
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|