I have 25 remote databases to upgrade in four states and doing the upgrade all at once just didn't work. I am now thinking about creating a version 11 consolidated database and then making the old consolidated a remote as well as keeping it as the old consolidated. I would sync from the old v9 database to the new v11 that way I can upgrade the remotes one at a time. I saw that I should use on the -xo switch on mlsrv to sync from the v9 db to v11. What I couldn't find is if I can use the same server for the upgraded remotes or if I need to have two instances of mlsrv with different ports?
asked 21 May '12, 16:46
You should probably start by upgrading the consolidated to V11 and make sure all the V9 remotes can synchronize with mlsrv11 -xo.
Then upgrade one remote and test that; run mlsrv11 with both -x and -xo and different ports.
Then proceed with the rest as your schedule / sanity / bar budget permits. There should be no reason to run the old consolidated as a remote... folks run varying versions of remotes all the time (and I mean all the time, in some cases forever).
See this this paragraph in the V11 Help...
SQL Anywhere 11 - Changes and Upgrading » What's new in version 10.0.0 » MobiLink » New features » MobiLink server
New -xo option for older clients
To connect the MobiLink server to version 8 or 9 clients, you should use the mlsrv10 -xo option, which is identical to the dbmlsrv9 -x option. You can support version 8 and 9 clients, as well as version 10 clients, from one instance of mlsrv10, but to do so you need to use two different ports.
answered 21 May '12, 16:59