Migrating From Version 15.x or Earlier Version Using BCP

You can use the bcp utility to migrate to the Cluster Edition from any Adaptive Server version.

See the Adaptive Server 15.5 Migration Guide, the Installation Guide for your platform, and the Utility Guide for complete instructions.

If you 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.

If you do not have DDL scripts, use the ddlgen utility to re-create the schema for the Adaptive Server you are about to upgrade. See the Utility Guide for syntax and usage information.

  1. Run dbcc checks on databases to verify data integrity.
  2. Use bcp to extract all the data from all the tables in the databases.
  3. Create a new Cluster Edition server in a new directory.
  4. Create devices, databases, and tables.
  5. Use bcp to bulk copy data into tables.
  6. Re-create all views, triggers, stored procedures.
  7. Run dbcc checks on the Cluster Edition server and make sure they run cleanly.
Parent topic: Migrating