To perform migrations, back up and restore databases using the
dump and load
commands.
- Run dbcc checks on all
databases in your original server and make sure they run cleanly.
- Create a Cluster Edition server in a new directory.
- 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.
- Dump the databases from the original server.
- Load the databases to the Cluster
Edition server.
- If you have partitioned tables, update partition
statistics.
- Run dbcc checks on the Cluster Edition server and make sure they run cleanly.