Using bcp to Migrate Data

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.
  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 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, and stored procedures.
  7. Run dbcc checks on the Cluster Edition server and make sure they run cleanly.
Parent topic: Migrate