Special Cases: Migrating to 64-bit Operating System or Larger Page Size

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.

NoteYou 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.

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.