You can use the bcp utility to migrate to the
Cluster Edition from any Adaptive Server version.
If you:
- Do not have DDL scripts, use the ddlgen utility to
re-create the schema for the Adaptive Server you are about to migrate. See
the Utility Guide.
- Have DDL scripts to create devices, databases, tables, rules, stored
procedures, triggers, and views, you can use bcp to move
data out of the old database and into the new.
- Run dbcc checks on databases to verify data integrity.
- Use bcp to extract all the data from
all the tables in the databases.
- Create a new Cluster Edition in a new
directory.
- Create devices, databases, and tables.
- Use bcp to bulk copy data into tables.
- Re-create all views, triggers, and stored procedures.
- Run dbcc checks on the Cluster Edition server and make sure they run
cleanly.