On some platforms, a 64-bit version of Adaptive Server is available. For some platforms, this is the only version available.
Adaptive Server version 12.5 and later allows you to create a server that uses a logical page size larger than 2K. See What’s New in Adaptive Server? for more information.
Table 3-1 describes the steps for migrating Adaptive Server in both cases.
Type of migration |
Methods/tools available |
|---|---|
Pre-15.0 32-bit server to 15.0 64-bit server |
You can use the sqlupgrade utility.
|
15.0 32-bit system to 15.0 64-bit system |
Create a new 15.0 installation and use bcp or dump and load to move data into the new server. You can also manually replace the binary to change to a 64-bit system. See the installation guide for your platform for more information. |
Pre-15.0 2K page server to 4K, 8K, or 16K server |
Changing Adaptive Server’s schema from one page size to another is a database migration rather than an upgrade. See Chapter 6, “Migration Utility” in the Utility Guide for information about migration. |
You can use the sqlupgrade utility
only when you are changing release levels. To move from a 32-bit
to a 64-bit system, start the 64-bit server against the 32-bit server installation.