SQL Anywhere database - Re: Database File Version

Author

Re: Database File Version

Nick Elson

2005-06-13, 11:23 am

The only 'file' version you can go by is the one recorded in the
database_version column of sys.sysinfo table as in

select database_version from sys.sysinfo

which will be different from what you are looking at. All the tools
(especially that database properties dialog) look at this value
instead

select @@version

which is the software version.

"Mohammad Alhabibi" <malhabibi@yalla.com> wrote in message
news:42ad46e7@forums
-1-dub...
> How to get the Database file version shown in the attached file using SQL
> ?
>
>
>

Breck Carter [TeamSybase]

2005-06-13, 1:23 pm

Just to be nitpicky <g>... AFAIK the database_version column contains
35 for all versions of 5.5 from 5.5.0 through 5.5.5. It is also fixed
at 41 for files created by 7.0.0 and later.

If someone can tell me how to tell apart files created by 5.5.0
through 5.5.3, I will share a (rather complex) technique that can be
used for all later versions.

FWIW it is very easy for 9.0.0 and later.

bRECK

There are other (rather complex) ways to tell file versions apart.
Some of them involve

On 13 Jun 2005 08:23:06 -0700, "Nick Elson"
< no_spam_nicelson@syb
ase.com> wrote:

>The only 'file' version you can go by is the one recorded in the
>database_version column of sys.sysinfo table as in
>
> select database_version from sys.sysinfo
>
>which will be different from what you are looking at. All the tools
>(especially that database properties dialog) look at this value
>instead
>
> select @@version
>
>which is the software version.
>
>
>
>
>
>
>"Mohammad Alhabibi" <malhabibi@yalla.com> wrote in message
> news:42ad46e7@forums
-1-dub...
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Nick Elson

2005-06-13, 8:23 pm

Breck. You simple can not tell the difference. They are all the same file
version
5.0.03 and 5.5.00 through to 5.5.05 [all were database_version=35]
simply
because there were no system catalog changes were made at any time through
that period of time.

About the only exception were Japanese databases, and they
were database_version=36.

Prior to 5.0.03, does it really matter any more? How many current platforms
are there that will run anything less than 5.5.05 plus last ebf?

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:lchra1tms8gi3vq
abc31t750jm1c9brimd@
4ax.com...
> Just to be nitpicky <g>... AFAIK the database_version column contains
> 35 for all versions of 5.5 from 5.5.0 through 5.5.5. It is also fixed
> at 41 for files created by 7.0.0 and later.
>
> If someone can tell me how to tell apart files created by 5.5.0
> through 5.5.3, I will share a (rather complex) technique that can be
> used for all later versions.
>
> FWIW it is very easy for 9.0.0 and later.
>
> bRECK
>
>
>
> There are other (rather complex) ways to tell file versions apart.
> Some of them involve
>
> On 13 Jun 2005 08:23:06 -0700, "Nick Elson"
> < no_spam_nicelson@syb
ase.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-06-14, 7:23 am

AFAIK 5.5.4 introduced SYSLOGIN and 5.5.5 added a fifth row to
SYSREMOTETYPE. Like you, I haven't figured out how to tell earlier
versions apart.

However, Mohammad's screen capture *seems* to indicate that Sybase
Central could tell the difference at the time; it displays "5.5.03". I
wonder how it did that?

Earlier versions of the *software* are of no interest, but earlier
versions of *files* are, to me, for the following reason: You can
start a V3.2 or 4.0 database with the V5.5 engine, and (AFAIK) you can
connect to that via remote access from a V9 engine.

Breck

On 13 Jun 2005 15:23:25 -0700, "Nick Elson"
< no_spam_nicelson@syb
ase.com> wrote:

>Breck. You simple can not tell the difference. They are all the same file
>version
>5.0.03 and 5.5.00 through to 5.5.05 [all were database_version=35]
simply
>because there were no system catalog changes were made at any time through
>that period of time.
>
>About the only exception were Japanese databases, and they
>were database_version=36.
>
>Prior to 5.0.03, does it really matter any more? How many current platforms
>are there that will run anything less than 5.5.05 plus last ebf?
>
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:lchra1tms8gi3vq
abc31t750jm1c9brimd@
4ax.com...
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Nick Elson

2005-06-14, 11:23 am

That is a pretty minor nit and doesn't count in my books Breck.

Since

- the extra row seems to have been 'FTP' (which was always
supported); at least according so some sample.db files I
still have some access to.

- the rows in that table are user modifiable so you can
always just add that yourself any time by adding it
through SQL Central or executing "CREATE REMOTE
MESSAGE TYPE FTP;"

- this missing row is even be possible with a 5.5.05 dbinited
database since (if you so chose to do so) a customer can
remove that row using "DROP REMOTE MESSSAGE
TYPE FTP;" or SQL Central

it is not really an upgrade or version issue.

Yes it can be a minor annoyance (yes I do remember living through it)
but not a file version issue at all.

It is not tied to structures. As far as I can tell, all SYS owned objects
are the same (in number and columns and parameters and types)

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:j2cta1lejh4c99b
f5nid4grv7hc7dic455@
4ax.com...
> AFAIK 5.5.4 introduced SYSLOGIN and 5.5.5 added a fifth row to
> SYSREMOTETYPE. Like you, I haven't figured out how to tell earlier
> versions apart.
>
> However, Mohammad's screen capture *seems* to indicate that Sybase
> Central could tell the difference at the time; it displays "5.5.03". I
> wonder how it did that?
>
> Earlier versions of the *software* are of no interest, but earlier
> versions of *files* are, to me, for the following reason: You can
> start a V3.2 or 4.0 database with the V5.5 engine, and (AFAIK) you can
> connect to that via remote access from a V9 engine.
>
> Breck
>
>
> On 13 Jun 2005 15:23:25 -0700, "Nick Elson"
> < no_spam_nicelson@syb
ase.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Breck Carter [TeamSybase]

2005-06-14, 1:23 pm

AFAIK SYS.SYSLOGIN was added sometime between 5.5.0 and 5.5.4.

The reason I am interested in the version used to initialize a file is
that there are often internal differences in the file structure
between versions. These differences may affect performance, but don't
necessarily have anything to do with catalog table differences;
catalog differences just *happen* to be visible to us lesser folk :)

I don't *know* if there are any file format differences between 5.5.0
and 5.5.5, I'm just mildly curious :)

Breck

On 14 Jun 2005 09:09:44 -0700, "Nick Elson"
< no_spam_nicelson@syb
ase.com> wrote:

>That is a pretty minor nit and doesn't count in my books Breck.
>
>Since
>
> - the extra row seems to have been 'FTP' (which was always
> supported); at least according so some sample.db files I
> still have some access to.
>
> - the rows in that table are user modifiable so you can
> always just add that yourself any time by adding it
> through SQL Central or executing "CREATE REMOTE
> MESSAGE TYPE FTP;"
>
> - this missing row is even be possible with a 5.5.05 dbinited
> database since (if you so chose to do so) a customer can
> remove that row using "DROP REMOTE MESSSAGE
> TYPE FTP;" or SQL Central
>
>it is not really an upgrade or version issue.
>
>Yes it can be a minor annoyance (yes I do remember living through it)
>but not a file version issue at all.
>
>It is not tied to structures. As far as I can tell, all SYS owned objects
>are the same (in number and columns and parameters and types)
>
>
>"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
>message news:j2cta1lejh4c99b
f5nid4grv7hc7dic455@
4ax.com...
>

--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com

Nick Elson

2005-06-15, 1:23 pm

5.5.03 ... but dbugrade will fix that one
but only if you really need to use integrated logins.

SQL Anywhere User's Guide
PART 3. Using SQL Anywhere
CHAPTER 15. Connecting to a Database
Using an integrated login
. . .
Restrictions
The integrated login feature was introduced and only works with release
5.5.03 engines and servers, and with databases that have been upgraded
to 5.5.03 standards. Databases created prior to release 5.5.03 can be
upgraded using the Upgrade utility.

and

SQL Anywhere User's Guide
PART 6. SQL Anywhere Reference
CHAPTER 50. SQL Anywhere System Tables
Alphabetical list of system tables
SYSLOGIN system table
. . .
This table contains all the User Profile names that can be used to
connect to the database using an integrated logon.

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
message news:s62ua19teuhv8th
i6d3qu1b27d2rav1kh4@
4ax.com...
> AFAIK SYS.SYSLOGIN was added sometime between 5.5.0 and 5.5.4.
>
> The reason I am interested in the version used to initialize a file is
> that there are often internal differences in the file structure
> between versions. These differences may affect performance, but don't
> necessarily have anything to do with catalog table differences;
> catalog differences just *happen* to be visible to us lesser folk :)
>
> I don't *know* if there are any file format differences between 5.5.0
> and 5.5.5, I'm just mildly curious :)
>
> Breck
>
> On 14 Jun 2005 09:09:44 -0700, "Nick Elson"
> < no_spam_nicelson@syb
ase.com> wrote:
>
>
> --
> SQL Anywhere Studio 9 Developer's Guide
> Buy the book:
> http://www.amazon.com/exec/obidos/A...7/risingroad-20
> bcarter@risingroad.com
> RisingRoad SQL Anywhere and MobiLink Professional Services
> www.risingroad.com

Sponsored Links