Hello:

We have a system which is using SQL Anywhere version 9 with
DB remote options and more than 50 remote clients. We are
planning a database upgrade to SQL Anywhere version 11.

Can we upgrade our server to SQL Anywhere version 11 without
upgrading the clients to SQL Anywhere version 11.

I've tried to extract the remote site from DBv11 (server
file using dbxtract of v11) and execute in the DBv9
file(client file using dbisqlc of v9) and its not working.

Executing the same reload.sql file working in DBv11 file.

Please help me to resolve this issue...

Thanks in advance
Robin

The version 11 dbxtract will create a version 11 database.
Since you want to run that on a V9 dbeng9 or dbsrv9
that simply won't work.

You should try dbxtract from the v9.0.2 installation.
[Of course that will also require dbeng9.exe to work.]
If for some reason that does not work, since it may not
recognize the V11 system catalog, then you will need
to consider building your own customer extraction.


"Robin" wrote in message news:4c800742.4c24.1681692777 (AT) sybase (DOT) com...

Thanks for your reply.

I've tried to extract remote site using dbxtract(v9.0.2)
from the V11 database file. But one error has come while
executing this..
--Adaptive Server Anywhere Extraction Utility Version
9.0.2.3274
--***** SQL error: Unable to start specified database:
C:\db\ms.db was created by a different version of the
software

I'm not aware about any customer extraction.. Is it possible
to upgrade server to version 11 without upgrading the
clients from version 9 using availbale options in sybase ?
We need to send messages from version 11 to version 9
database ..

Once again thank you very much for your time and
consideration..

Robin

If ms.db is your V11 consolidated database, that too
would be expected. You need to start that with
either dbsrv11.exe or dbeng11.exe and connect to
it.


"Robin" wrote in message news:4c80f8c2.5ddf.1681692777 (AT) sybase (DOT) com...

And ... uh ... that should have stated

,as in, build your own, scripted and/or templated process
to do the extraction. Many customers have done that
for various reasons that dbxtract was never designed
for.


"Nick Elson [Sybase An SAP Company]" <@nick@dot@elson@at@sybase@dot@com@>
wrote in message news:4c810f3b$1 (AT) forums-1-dub (DOT) ..

Yes, Robin, you can upgrade the consolidated and each remote
independently from v9 to any newer versions. Consequently, you can also
leave all your remotes on v9.
SQL Remote is built to work with different versions smoothly.

What you have noticed, is a changed behaviour with v11/v12 and only
relates to DBXTRACT (cf. the docs
http://dcx.sybase.com/1200en/sachang...b-3789082.html) -
to quote:

"Extraction utility (dbxtract) behavior change
In previous releases the version of dbxtract used to extract a database
did not have to be the same version as the database server running the
database. Now, when dbxtract is used with a version 10.0.0 or later
database, the version of dbxtract used must match the version of the
database server used to access the database. If an older version of
dbxtract is used with a newer database server, or vice versa, an error
is reported."

So when you rely on DBXTRACT to extract your databases, you will have to
use the v11 DBXTRACT, and typically the resulting reload.sql script will
not work with a v9 database as it will contain SQL language elements or
system objects that a v9 database engine just does not know.

As Nick states, you will then have to upgrade new remotes (and the ones
who need to be re-extracted) to v11, or you will have to build your own
custom replacement for DBXTRACT (like lots of folks have done).

HTH
Volker


Robin wrote: