Tutorial: Changing a schema using the ScriptVersion extended option

This tutorial demonstrates how to perform a schema change when you are using the ScriptVersion extended option.

Note

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.

 Required software
 Overview

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