I would like to upgrade an SQL Anywhere 11 database to version 12. I started the version 11 database file with a version 12 database server. I then used Sybase Central to unload the database. I used Tools > SQL Anywhere 12 > Unload Database... I then followed the screen messages, starting with the first choice: Unload a database running on a curent version of the server. Then I chose Unload and reload into a new database. I saved it into a new database file (with Unload structure and data etc. set). As a result I got a database file and the log file. I assume this is now a real version 12 database and log file?
Best regards, Robert
PS: By the way, how can I verify the db file version it is/was built?
Yes this should be a version 12 database.
You can verify that by looking at the SYS.SYSHISTORY system view.
answered 15 Apr '11, 12:36
I would generally recommend to rebuild a database for a new version if that is possible. It's the only way to get access to all new features of the new version.
However, it makes it necessary to put down the database for a certain time, and rebuilding a huge database will need some time. Therefore that may be not easily doable for a database used 24x7. If you can't afford the time needed for a complete reload, you can alternatively
As you can see, these alternatives have different trade-offs to give you several choices.
As to SYSHISTORY, the "INIT row" will name the version the database will be built with - for a reloaded database that's the version it was rebuilt with.
The "UPDGRADE row" will tell to which version(s) the database was upgraded to.
If you are not sure whether your database was successfully rebuilt with v12 (though the Sybase Central Wizard should tell you a failure), the "INIT row" should assure you that your version is build with v12.
answered 16 Apr '11, 16:52