analyse database

[Former Member]

Hi,

I've got a database file (*.db) from a customer who asks me to analyse its content. All what he knows is that it's a SQL Anywhere database, but no version number.

I've already downloaded SQL Anywhere Developer version 12 and 10. But both products reports a connection error, that this database was created with another version.

So how can I detect the database version to download the right developer suite ?

[MarkCulp]

SQL Anywhere is designed to be backward compatible so that newer versions of the software can open and use database files that have been created with older versions of the software. There is one exception to this: Software versions 10 and up cannot open database files created with version 9 and below.

So in your situation one of two cases must be happening:

• the database from your customer is created with versions 9 or lower, or
• the database file is created with a version beyond v12 (which is highly unlikely!).

To determine the version of the database you can use the DBCreatedVersion() function in the dbtools library.