New Features and Upgrading Guide
CHAPTER 5. Upgrading to Adaptive Server Anywhere
A database application and DBMS consists of several components. If your organization has a large SQL Anywhere installation, you may have many client machines, possibly running several applications, connected to more than one server.
When upgrading your system, you need to decide which components to upgrade, and in which order. This chapter guides you in making those choices and carrying out the upgrade.
SQL Anywhere Version 5 |
In order to upgrade existing applications to Adaptive Server Anywhere Version 6, it is helpful to understand how Version 6 connections work. For information, see Connecting to a Database.
Standard upgrade precautionsThere are several precautions you should take before upgrading any application, and these apply to Adaptive Server Anywhere upgrades just as to any other software.
Check the behavior changes Before upgrading, you should confirm that none of the documented behavior changes in Version 6 affect your application.
For information on behavior changes, see Behavior Changes.
Test You should test your application in a Version 6 environment thoroughly before upgrading any applications in production use.
Backup You should back up your existing software and data before upgrading.
Test your upgrade procedure If you are upgrading many end users, test your upgrade procedure carefully before carrying it out.
SQL Anywhere is used in so many different configurations that no upgrade guidelines can be guaranteed for all cases.
The components in your systemIf you are currently running SQL Anywhere Version 5, you will have some or all of the following components in your system:
Application Your application, aside from the SQL Anywhere components.
Connection parameters SQL Anywhere Version 5.0 connection parameters. These may be assembled from an ODBC data source, or in some other way.
Driver manager The ODBC driver manager, for ODBC applications.
ODBC driver The SQL Anywhere Version 5 ODBC driver, for ODBC applications. For network applications, the ODBC driver is on the client machine.
Interface library The SQL Anywhere Version 5 interface library is used by ODBC and Embedded SQL applications. For network applications, the interface library is on the client machine.
SQL Anywhere client The dbclient.exe executable and its command line, for network applications. The command line may specify the server name, and a set of network communications parameters. It may be stored in a batch file or an ODBC data source Start Line parameter. For network applications, the SQL Anywhere client is on the client machine.
The database server The SQL Anywhere Version 5 database server. For network applications, this may be on a separate machine from the client components.
The database A SQL Anywhere Version 5 database. This is on the same machine as the database server.
Database upgrades not required |
Major upgrading issuesThe major issues in upgrading arise from the change in client/server communication protocol. This change means that the Version 5 interface library is not able to communicate with a Version 6 database server.
To help with this issue, Adaptive Server Anywhere Version 6 includes a compatibility library. This DLL allows communications to both Version 5 and Version 6 database servers.
The new client/server communications protocol is described in New communications features.
When to upgrade your databaseThere is no need to upgrade the database itself when you start using Version 6. You need to upgrade the database only if you wish to take advantage of Version 6 features.
For more information on upgrading databases, see Upgrading databases.
Running more than one version of the softwareThe Adaptive Server Anywhere software is designed so that both Version 5 and Version 6 can be run if you install Adaptive Server Anywhere Version 6 in a separate directory from SQL Anywhere Version 5. This is the default behavior of the Adaptive Server Anywhere installation program.