Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

I used ASA12 and then ASA16 dbupgrad utility, start upgraded database on ASA16 and connect it with Central 12, but not with Central 16.

Is there any way to upgrade Sybase SQL Anywhere 10 database to version 16 without a reload accepted by the Sybase Central 16?

I looked at the answer on Ohad's question: Sybase Central won’t work after upgrade database to version 16.0.02019 (question 25651)

Thanks Jan

asked 16 Mar '16, 09:20

Jan24's gravatar image

Jan24
75348
accept rate: 0%

1

Sybase Central only supports databases created with v11 or later. You can use Sybase Central v12 to manage the SA10 initialized database file or rebuild the database using v11 or later if you need to use Sybase Central v16.

(16 Mar '16, 09:39) Chris Keating
Replies hidden

Thank You. Currently, it is used Central v12. We assume that to the database missing little to no problem with it.

(16 Mar '16, 10:07) Jan24

Just to add: The limitation to "only support 2 major versions back" does not apply to DBISQL (nor dbisqlc), i.e. you can of course use all appropriate SQL statements to manage a v10 database from a v16/v17 DBISQL utility...

(16 Mar '16, 10:12) Volker Barth

The only complete way to fully upgrade a database is to rebuild it. Doing so, will introduce new database structure that are required for some new capabilities. Running dbunload -an <new.db> is the simplest way to do that; but either way a new database needs to be created/dbinit-ed at some point in the process.

Sybase Central, as of verson 16, will only open databases "created by version 11 or later"

versions 11 or later

because it assumes there is a base-line of features that require newer database structures.

This is consistent with the philosophy that some modules (Mobilink, some Admin tools including scjview, ...) can/may only support 2 major versions back.

permanent link

answered 16 Mar '16, 09:55

Nick%20Elson%20SAP%20SQL%20Anywhere's gravatar image

Nick Elson S...
7.3k35107
accept rate: 32%

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:

×260
×128
×62

question asked: 16 Mar '16, 09:20

question was seen: 2,194 times

last updated: 16 Mar '16, 10:12