To perform migrations, back up and restore databases using the
dump and load
commands.
- 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.
- Create a 64-bit server in a new directory.
- Create devices and databases to match those in the 32-bit server. Make sure the sysusages mapping is correct.
Note: Allow 10 percent additional space for the
sybsystemprocs database.
- Dump the databases from the 32-bit server.
- Load the databases to the 64-bit server.
- If you have partitioned tables, update partition
statistics.
- Run dbcc checks on the 64-bit server and make sure they run cleanly.