Migrating

For complete instructions about using dump and load to migrate to the Cluster Edition, see the Adaptive Server 15.5 installation guide for your platform.

  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 that 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.