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

ClarenceA's gravatar image

ClarenceA
46114
accept rate: 0%


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.

permanent link

answered 02 Oct '13, 11:47

Jeff%20Albion's gravatar image

Jeff Albion
10.7k171174
accept rate: 24%

Thanks. [Gracias]

(02 Oct '13, 13:20) ClarenceA

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

(03 Oct '13, 17:52) gg99

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.

(03 Oct '13, 17:55) gg99
Replies hidden

Off topic

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

(04 Oct '13, 03:41) Volker Barth

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.

permanent link

answered 05 Oct '13, 10:27

pasha19's gravatar image

pasha19
2755717
accept rate: 14%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×54

question asked: 02 Oct '13, 11:39

question was seen: 856 times

last updated: 05 Oct '13, 10:27