Migrating Data Using a Dump-and-Load Method

To perform migrations, back up and restore databases using the dump and load commands.

  1. Run dbcc checks on all databases in your original server and make sure they run cleanly.
  2. Create a Cluster Edition server in a new directory.
  3. Create devices and databases to match those in the Cluster Edition server. Make sure the sysusages mapping is correct.
    Note: Allow 10 percent additional space for the sybsystemprocs database.
  4. Dump the databases from the original server.
  5. Load the databases to the Cluster Edition server.
  6. If you have partitioned tables, update partition statistics.
  7. Run dbcc checks on the Cluster Edition server and make sure they run cleanly.
    For information on upgrading compiled objects, see Finding Compiled Object Errors Before Production.
Parent topic: Migrate