We have SQL AnyWhere 9 and I want to upgrade to SQL AnyWhere 16. Is there a document with instructions how to do the upgrade?
asked 02 Oct '13, 11:39
See the documentation for the upgrade steps on various SQL Anywhere components: http://dcx.sybase.com/index.html#sa160/en/sachanges/v10upgrade.html
Specifically, you will at least have to perform a database rebuild in order to bring the version 9 database file format into the version 10+ format: http://dcx.sybase.com/index.html#sa160/en/sachanges/unloading-reloading-upgrading-newjasper.html
Performing a backup of your database prior to performing an upgrade is recommended: http://www.sybase.com/files/White_Papers/SQLA_SA_backup_070307-wp.pdf
and finally, be sure to thoroughly test any database applications with the new database version prior to being deployed to production. Testing should include both functionality and performance testing.
answered 02 Oct '13, 11:47
I saw a prior webpage that referenced this can be done using DBUNLOAD. There was a potential glitch mentioned on that page -- SQLANYWHERE 9 I believe was named ASA9 and uses an ASTMP environment variable for the temp file path SQLAnywhere16 uses an SATMP environment variable for the temp file path. There was a note that dbunload might require both environment variables to create temp files for the conversion using DBUNLOAD. This process worked for me converting the ASA9 sample database.
answered 05 Oct '13, 10:27