Features requiring an unload/reload, upgraded database, or updated client libraries

Many features are available when you upgrade your SQL Anywhere database server. While many features are available when you run an older database on the latest version of the database server, to access some features, you must unload and reload your database, perform an upgrade on the database file, or update your client libraries.

Before version 10, the SQL Anywhere database server was called Adaptive Server Anywhere.

Note

Features not listed in the categories below only require a SQL Anywhere 12.0.0 database server, they do not require the database to be upgraded or the client libraries to be updated. For a complete list of new features in SQL Anywhere 12, see What's new in version 12.0.0.

Features that require an unload/reload of your database

General performance enhancements. See Performance enhancements.
UltraLite: UltraLite version 12 cannot connect to databases created with earlier versions of UltraLite. Therefore, an unload/reload is required. However, UltraLite version 11 can synchronize with MobiLink version 12.

Features that require only an upgrade (dbupgrad utility or UPGRADE DATABASE statement)

Features that require only an upgraded database also work if you unload/reload your database.

Indexing performance enhancements. See Improved index performance in SQL Anywhere 12.0.0.
Spatial data support features. See Support for spatial data.
TIMESTAMP WITH TIME ZONE. See New TIMESTAMP WITH TIME ZONE data type.

Features that require updated client libraries

Connection pooling. See SQL Anywhere connection pooling.
Progress messages. See New progress_messages option.
Idle timeout on shared memory connections. See Behavior change for the Idle connection parameter.
TIMESTAMP WITH TIME ZONE. See New TIMESTAMP WITH TIME ZONE data type.
Spatial data support on the client side. See Support for spatial data.
SQL Anywhere JDBC driver. See New SQL Anywhere TYPE-2 JDBC driver.

Discuss this page in DocCommentXchange.