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.
In the 32-bit Adaptive Server, run dbcc checks (checkdb, checkalloc, checkcatalog and checkstorage)
on all databases in the 32-bit Adaptive Server to ensure they
are error-free.
Use bcp to extract all the data from
all the tables in the databases.
Create a new 64-bit Adaptive Server 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 64-bit server
and make sure they run cleanly.