In this lesson, you synchronize again with the schema changes.
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.
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.
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|