Database Upgrades

Important information about database upgrades.

For detailed information about installing and upgrading Sybase IQ, see the Installation and Configuration Guide.

Drop Global Temporary Tables Before Running iqunload [CR #717855]

Use DROP TABLE statements to drop all global temporary tables before you run the iqunload utility. You can recreate global temporary tables after migration.

iqunload migrates 12.7 FPIDX databases that use the asejebc remote data access class [CR #682589]

Although the asejdbc server class is deprecated, the iqunload tool migrates remote server definitions based on the asejdbc driver from Sybase IQ 12.7 databases to Sybase IQ 15.4. Set the cis_option to use the remote server at runtime.

Sybase Central Plug-in Compatibility [CR #667451]

Due to security fixes in IQ 15.3, the Sybase IQ 15.4 plug-in for Sybase Centralâ„¢ and Sybase Central Agents are not compatible with versions of Sybase IQ earlier than 15.2 ESD #3. You can use the 15.4 plug-in only with Sybase IQ servers that are 15.2 ESD #3 or later, including 15.4; you cannot use the 15.4 plug-in to connect to 12.x servers or servers earlier than 15.2 ESD #3. See New Features Summary.

Upgrade Invalidates Data Source Names [CR #487858]

In Sybase IQ 15.x, 32-bit drivers are located in the bin32 directory, instead of win32, and 64-bit drivers are now in the bin64 directory, instead of x64. Therefore, when migrating from 12.x to 15.x, you may need to update registries and applications to locate libraries. For example, win32\dbodbc11.dll is now in bin32.

Default Password Value Change

The default password is sql in lowercase.