I have two databases that are replicating via SQL remote. (It's working beautifully -- thank you Breck!). But they are running on 9.0.2.
The reason I have two databases is that I need to have some applications live 24x7 -- and if we have a catastrophic failure of a database server, I can move the apps to the other server in minutes, rather than the hours it would take to restore a backup to another machine. We can also point reporting applications (big slow queries) to a different physical machine than the transactions which must be fast.
The current situation is that all apps are pointed to the remote database. The consolidated database does nothing all day long.
So, I'm thinking I could do this:
I think it really all depends on whether SQL Remote can handle replication across version levels.
Thoughts? Thank you.
asked 17 May '10, 22:08
As to the underlying question "Must all SQL Remote sites be upgraded at the same time?", the docs definetely say: No. Cf. the topic Upgrading SQL Remote , as cited here
And if it were differently, how could anyone with, say, a few hundred remotes ever upgrade to a newer SQL Anywhere version...
The main caveat (besides the necessary steps to rebuild a database involved in replication, see my comment above) is to make sure the following file is included in the setup if SQL Remote at an upgraded site has to access older (i.e. pre V10) log files:
"The Pre-10 physical store library" dboftsp.dll (on Windows).
answered 18 May '10, 14:10
Make sure replication is caught up, unload/reload the consolidated, re-extract the remote.
answered 17 May '10, 23:17
It seems to me like I have to REVOKE and GRANT REMOTE to users on both sides before I can get the replication up and running again. That cannot be correct, since I think it would be mentioned somewhere if I had to...
I tried to upgrade a consolidated database from ASA9 to SA12, when I run SQL Remote afterwards it looks for the log offset in the old transaction log, which naturally does not exist in the new transaction log file.
answered 09 Dec '11, 07:47