on 06-14-2022 8:08 PM
I need to download and install Sybase Central 11 to a PC to be able to manage a SQLAnywhere 11 database that is currently in use. Where can I find that download? Thanks.
SQL Anywhere 12.0.1 client is available for download from SAP SQL Anywhere Database Client Download - SAP SQL Anywhere - Community Wiki. Sybase Central 12 will be able to connect to a SQLA 11 database server.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
This is a mission critical SQL Anywhere 11 database that can't be upgraded at this time. I am worried that modifying that database using Sybase Central 12 or 17 might cause some sort of conflict, corruption, or upgrade to the database. We have other server code also accessing and modifying that database via version 11 SDK, dlls, etc... What would happen if you modified a version 11 database with Sybase 12 or 17? When creating a new database with 12 or 17, would it automatically create them in the newer version rendering any existing compiled code obsolete? I am concerned about mixing and matching versions.
Upgrading SQL Anywhere provides information about using Sybase Central with different server versions. In particular, refer to the section Compatibility with existing software (the last section of this page). It states that "[y]ou can manage old databases and old database servers from the current version of Sybase Central ... [and can] connect to and administer version 9 and later databases running on version 9 and later database servers". This section also describes which client and server version combinations are permitted and any limitations.
You cannot use SQL Central 17 to maintain a version 11 database (note that the admin tool name has been changed). Of the available SQL Anywhere Client standalone installs that are available, your only option is SQL Anywhere 12 Client.
It is more likely that installing a SQL Anywhere 11 Sybase Central would introduce conflicts unless you can ensure that its version and build match the version and build of your SQL Anywhere 11 environment. You will not corrupt a database using a different major version client software. You should not perform an upgrade (dbupgrad) or unload (dbunload) using a different major and minor version of the client software than the server version. If you are concerned that may accidently occur, rename or delete the dbupgrad.exe and dbunload.exe in the SQL Anywhere 12 Client install location. i.e., %sqlany12%\binX where x is the bitness (32 or 64).
If you are still concerned with using SQL Anywhere12 client to manage your SQL Anywhere 11 production environment, all functionality of Sybase Central can be performed with command line utilities or SQL statements.
User | Count |
---|---|
84 | |
24 | |
12 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.