is there any doc path to upgrading SQL AnyWhere9 to 16

[former_SQLA_member1695007]

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?

[jeff_albion]

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.

[former_SQLA_member1695007]

Thanks. [Gracias]

[g_g_99]

specifically test any stored proc or procedurethat uses outerjoin to avoid unexpected and difficult to debug problems

[g_g_99]

off topic, Jeff, how do I get copy of the developer version of the sa 16? I went thru the process of filling the form, no response, sent email per forms and got bounced. called support, got the run around, even worse got cut of form some eager for quicl sale or large sale rep.

[VolkerBarth]

Off topic

I'd suggest to ask that as a separate question:) (And no, I don't have the answer)

[Former Member]

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.