on a developer Vista 64 PC, there is runtime installed for sa 10 installed.
..net applications using fw 3.5 are running perfectly with access to the
database via a system ODBC dataset using integrated security and sa10
drivers.

The database is relatively small and simple: 10 MB, 40 tables plus indexes
and store procedure and functions

Now I need to add some columns for some tables for the SA 10 Database.
there was an old Xp development for the SA10 but it just died
Is it safe to use SA11's Central 6 to access the database using SA 10
drivers and add columns?

I will make backup copy of the database at OS level first of course.
or would it be better that I uninstall SA 11 totally and install SA 10,
then SA11?...

SA11 is not ready for deployment in this environment as it is still under
evil and test.

You should be able to use Sybase Central from V11 to modify a version 10
database.... you can also run a version 10 database file using a version
11 engine.

I see no need to uninstall/reinstall the two SQL Anywhere versions.

Glenn

gg wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

great to hear. thx

however, the word should does lead me to ask:
- under what circumstance I should not
- what can be potential problem I should be watch for?

I did alter a table on a copy, and changes some permission on some tables in
Sybase central 6 for SA11 and seemed to be OK even after repeated restart of
the database and between sessions

"Glenn Paulley [Sybase iAnywhere]" <paulley (AT) ianywhere (DOT) com> wrote

There are no known problems with using Sybase Central from V11 with a
version 10 database. There are new SQL language features and syntactic
changes in version 11 that (obviously) version 10 does not support.
However, Sybase Central is aware of these differences and should not
generate version 11 syntax that will fail with a version 10 database.

Glenn

gg wrote:
--
Glenn Paulley
Director, Engineering (Query Processing)
Sybase iAnywhere

Blog: http://iablog.sybase.com/paulley

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports: http://case-express.sybase.com

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

Whitepapers, TechDocs, and bug fixes are all available through the
Sybase iAnywhere pages at
http://www.sybase.com/products/datab...chnicalsupport

Excellent. thank you.

"Glenn Paulley [Sybase iAnywhere]" <paulley (AT) ianywhere (DOT) com> wrote