Sybase 12.4.2 - Manual (Page 39)

CHAPTER 1 Overview of Adaptive Server IQ System Administration
19
For more information on the utility database, see Chapter 3, “Configuring
Client/Server Communications” in your Adaptive Server IQ Installation and
Configuration Guide.
Compatibility with earlier versions
Version 12 of Adaptive Server IQ differs markedly from earlier versions of IQ.
It offers many important new features, including the ability to update the
database concurrently with query use, Transact-SQL and Java support,
additional query and view support, and better front end support. It offers
syntactic compatibility with Adaptive Server Anywhere, allowing Anywhere
users to build on their existing knowledge base as they begin to use IQ. It also
includes a new, more efficient database format.
These last two features have special implications for users migrating from pre-
version 12 Adaptive Server IQ. When you migrate to version 12, you must:
• Examine any scripts, applications, and procedures for differences in
syntax, and make the necessary changes.
• Reload your IQ database, using the special migration procedure.
See the Adaptive Server IQ Installation and Configuration Guide and the
Adaptive Server IQ Release Bulletin for your platform for migration details.