This tutorial demonstrates how to perform a schema change when you are using the ScriptVersion extended option.
It is recommended that you avoid using the ScriptVersion extended option if possible. Instead, associate your script version with your subscription using the SCRIPT VERSION clause of the CREATE SYNCHRONIZATION SUBSCRIPTION statement or the SET SCRIPT VERSION clause of the ALTER SYNCHRONIZATION SUBSCRIPTION statement. These implementations give you more flexibility to perform schema upgrades.
Lesson 1: Creating and configuring the consolidated database
Lesson 2: Creating and configuring the remote database
Lesson 3: Synchronizing the remote database
Lesson 4: Performing a schema change on the consolidated database
Lesson 5: Performing a schema change on the remote database
Discuss this page in DocCommentXchange.
|Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1|