Installation guide
2.
Create a 64-bit server in a new directory.
3.
Create devices and databases to match those in the 32-bit server. Make sure the
sysusages
mapping is correct.
Note: Allow 10 percent additional space for the sybsystemprocs database.
4.
Dump the databases from the 32-bit server.
5.
Load the databases to the 64-bit server.
6.
If you have partitioned tables, update partition statistics.
7.
Run dbcc checks on the 64-bit server and make sure they run cleanly.
For information on upgrading compiled objects, see
Finding Compiled Object Errors
Before Production
on page 102.
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 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.
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.
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, and stored procedures.
7.
Run dbcc checks on the 64-bit Adaptive Server server and make sure they run cleanly.
Migrating Data by Replacing the Binary
Migrate data from a 32-bit server to a 64-bit server by replacing the binary.
1.
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.
2.
Copy the files for the 64-bit Adaptive Server into a new directory.
3.
Shut down the 32-bit server.
CHAPTER 10: Adaptive Server Upgrades
Installation Guide 93