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.

  1. Run dbcc checks on all databases in the 32-bit Adaptive Server and make sure they run cleanly.
  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 on 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 Upgrading Compiled Objects With dbcc upgrade_object.
Parent topic: Migrating from 32-bit to 64-bit Versions on Different Computers