As of release 11.9.3, Adaptive Server runs on 64-bit operating systems. As of 12.5, ASE allows you to create a server that uses a logical page size larger than 2K in order to store more data per page. These changes are described in What’s New in Adaptive Server Enterprise and the Performance and Tuning Guide.
If you wish to take advantage of these changes, you need to select the appropriate migration method. These are the options currently available:
Type of migration |
Methods/tools available |
|---|---|
Pre-12.5 32-bit server to 12.5 64-bit server |
You can use the sqlupgrade utility.
|
12.5 32-bit system to 12.5 64-bit system |
Create a new 12.5 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 instructions. |
Pre-12.5 2K page server to 4K, 8K, or 16K server |
As of the release of this manual, an upgrade to a larger page size is not supported. You need to rebuild the system using the instructions for 32-bit to 64-bit migration in the installation guide. Watch the ASE Migration Resources Web page for developments on tools to aid data migration to larger page size. |
You can use the sqlupgrade utility
only when you are changing release levels. You cannot use it just
to move from a 32-bit to a 64-bit system.