As your needs evolve, deployed remote databases may require schema changes. The most common schema changes are adding a new column to an existing table or adding a new table to the database.
Previously, schema changes that affected synchronization required a successful synchronization immediately before making the schema change. This is no longer required. To do this, you must use new SQL syntax to store the script version on the synchronization subscription instead of using the ScriptVersion extended option.
The SQL syntax to support this feature is as follows:
CREATE SYNCHRONIZATION SUBSCRIPTION statement Use the SCRIPT VERSION clause to specify the script version to use during synchronization.
ALTER SYNCHRONIZATION SUBSCRIPTION statement Use the SET SCRIPT VERSION clause to specify the script version to use during synchronization.
Script versions and subscriptions
Adding tables to deployed SQL Anywhere remote databases
Altering a published table in a deployed SQL Anywhere remote database
Schema upgrades for UltraLite remote databases
Discuss this page in DocCommentXchange.
|Copyright © 2014, SAP AG or an SAP affiliate company. - SAP Sybase SQL Anywhere 16.0|