Using BCP to Migrate Data

If you use DDL scripts to create devices, databases, tables, rules, stored procedures, triggers, and views, you can use bcp to migrate data from a 32-bit Adaptive Server to a 64-bit Adaptive Server.

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.

  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 64-bit Adaptive 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 64-bit server and make sure they run cleanly.
Parent topic: Migrating from 32-bit to 64-bit Versions on Different Computers