Migrating from 32-bit to 64-bit Versions on Different Computers

To migrate Adaptive Server from the 32-bit to the 64-bit version, first install and configure the 64-bit operating system.

There are three ways to migrate data on different computers:

Using dump and load
Using BCP
Replacing the binary

After upgrading or migrating to other platforms, the server internally rebuilds procedures using the text in syscomments as it is first executed.

syscomments may not execute properly if it has code that drops existing objects and recreates them. Manually drop objects prior to executing syscomments for the first time.

Migrating Data Using a Dump and Load Method
Learn how to migrate data using a dump and load method to migrate data from a 32-bit to a 64-bit Adaptive Server version.
Using BCP to Migrate Data
If you use DDL scripts to create devices, databases, tables, rules, stored procedures, triggers, and views, you can use bcp to migrate data from a 32-bit Adaptive Server to a 64-bit Adaptive Server.
Migrating Data by Replacing the Binary
You can migrate data from a 32-bit server to a 64-bit server by replacing the binary.

Parent topic: Upgrade