MobiLink: How to propagade schema change for a synch profile to remote databases

Question

Once an application is online with a synchronisation profile it might happen, that the profile needs to be changed. E.g. a new index is introduced, columns are added etc.

Having the synchronisation profile created with Sybase Central, what's the designated way to propagate these changes to remote databases? The only option here seems to be to complete new create a profile or update current one including complete regeneration of remote database.

Answer 1

Mobilink can also pass schemachanges to it's replicated databases. For this, there exists the start synchronization schema change statement

This looks like this:

START SYNCHRONIZATION SCHEMA CHANGE
  FOR TABLES DBA.Sales, DBA.Products
  SET SCRIPT VERSION = 'version_2';
ALTER TABLE DBA.Sales ADD SUBTOTAL NUMERIC (10,2);
ALTER TABLE DBA.Products ALTER QUANTITY BIGINT;
STOP SYNCHRONIZATION SCHEMA CHANGE;