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

SQL Anywhere 12.0.0 » MobiLink - Client Administration » Introduction to MobiLink clients » Schema changes in remote clients

 

Introduction to MobiLink client schema changes

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. In order 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: