2

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.

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;
4
  • This I have found. But was wondering whether this can be triggered directly via Sybase Central which is considered based upon documentation as single point of configuration.
    – frlan
    Jul 28 '15 at 7:32
  • I don't think so. Also for SQLRemote you have to make this manually. It is just to dangerous to have done this implicit by Sybase Central Jul 28 '15 at 7:37
  • Hmmm. I was afraid of this answer. Inconsistent as the rest at least. Anyway, upvote is sent out ;)
    – frlan
    Jul 28 '15 at 7:39
  • At dba.stackexchange.com/a/108679/30833 I found a way which is might more "Sybase Central" like.
    – frlan
    Jul 31 '15 at 15:30

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.