This general question has come up based on that FAQ by Justin:
If an older SQL Anywhere database can be run unchanged on a newer SQL Anywhere engine (say, a v10 or v12 database can run on a v16 engine), does that also mean the database file can later be run on the older original engine, too (so it's compatible both "upwards and backwards")?
I.e. if I run an older database file on a newer engine and neither do a rebuild nor an upgrade, is it guaranteed (ignoring possible software bugs) that this will not impact the ability of the database file to run on the older engine?
I always thought so, but possibly these are two different facets.
(Even is the answer is true, it's certainly important to do a proper backup before trying to use the newer version, apparently.)
I'm relating to major versions here, not different EBFs/SPs or different maintenance release versions.
asked 24 Feb '16, 06:40
Unless you rebuild or, otherwise, upgrade the database file structures remain the older version and you should be able to switch back to the original version of the software at any point. That is a design point of the product (much like platform independence of the database files) and barring unforseen circumstances (like a bug or corruption) should be behaviour you can expect.
answered 24 Feb '16, 08:50
Nick Elson S...