Migrating Data Using a Dump and Load Method

Migrate data using a dump and load method to migrate data from a 32-bit to a 64-bit Adaptive Server version.

1. In the 32-bit Adaptive Server, run dbcc checks (checkdb, checkalloc, checkcatalog and checkstorage) on all databases in the 32-bit Adaptive Server to ensure they are error-free.
2. Create a 64-bit Adaptive Server in a new directory.
3. Create devices and databases to match those in the 32-bit server. Make sure that the sysusages mapping is correct.
   Note: Allow 10 percent additional space for the sybsystemprocs database.
4. Dump the databases from the 32-bit server.
5. Load the databases to the 64-bit server.
6. If you have partitioned tables, update partition statistics.
7. Run dbcc checks on the 64-bit server to ensure they run cleanly.
   For information on upgrading compiled objects, see Finding Compiled Object Errors Before Production.