We are planning to make DDL changes to our SQL Anywhere 16 remote databases. We have decided to re-extract the remote databases rather then push the changes out to them. We plan to only change the synchronization script version that the remotes use. That is, we would like to use the same MobiLink usernames, MobiLink server/port, etc. Since we will be using the same MobiLink usernames, is there a way to prevent users from synchronizing with the old database/script version? Can you disable/delete the old script version?
asked 06 May '15, 14:18
To answer your question, yes, data in the ml_tables on the consolidated database can be deleted... but:
If you are not going to run synchronizations using both the old and the new versions, there may not be any reason to change the version... just replace all the scripts for the original version. This is done all the time when bugs are fixed: the scripts are changed and then they are all reloaded; it is convenient to have all the MobiLink scripts in one (or a few) *.sql text files.
Multiple script versions are useful when some remotes are upgraded and some are not, and the "not" remotes must still synchronize using the old version of the MobiLink scripts.
answered 07 May '15, 07:26