Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SAP Sybase SQL Anywhere 16.0 » MobiLink - Getting Started » MobiLink tutorials » Tutorial: Changing a schema using the script version clause


Lesson 6: Performing a schema change on the remote database

In this lesson, you modify the remote database to add the new column to the customer table and to change the script version used to synchronize.


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.

  1. Start a synchronization schema change. This is required for most schema changes that affect synchronizing tables. This statement changes the script version that is used to synchronize the subscription, and locks the affected table so the schema change can proceed safely.

    Execute the following SQL statement on the remote database using the instance of Interactive SQL that is connected to the remote database.

    FOR TABLES customer
    SET SCRIPT VERSION = 'my_ver2';
  2. Add the new column to the customer table by executing the following SQL statement.

    ALTER TABLE customer ADD cell_phone VARCHAR(12) DEFAULT NULL;
  3. Close the schema change, which unlocks the tables.



A synchronization schema change is performed on the remote database.


Proceed to Lesson 7: Inserting data.