Sybase Central – How to Set Language for UI

Sybase's SQL Anywhere has startup parameters to control the min/max cache settings.

  -c  for the initial cache memory setting
  -ch for the maximum cache memory setting
  -ci for the minimum cache memory setting

If you set these appropriately it should constain the memory usage from the cache.

Here is a SQL Anywhere 12.0 page with those settings: http://dcx.sybase.com/1200/en/dbusage/limiting-using-perform.html

This seems¹ to work:

1. Create a new Remote Schema Name (e.g. v2.0)
2. Do changes on your consolidated database (e.g. CREATE TABLE-statement)
3. Update schema inside your synchronisation profile and maybe increase version string (on my current test it appears to doesn't matter)
4. Do a deployment of your update synchronisation profile. You will need update ml_columns and ml_tables as well as ml_table_scripts etc on your consolidated database fitting your update synchronisation profile. So apply the changes to it. Also you will need the SQL of remote database
5. Create an upgrade remote task including the remote SQL created with step 4 (EXECUTE SQL). This task should also change Remote Schema Name
6. Maybe iterate your sync- task and deploy both -- upgrade task and sync task
7. Should be done

The biggest issue is, that the script in default is droping the tables on remote side so a huge amount of data might be transferred after update.

¹ I was able to get this running on a local test scenario with minimum database.