You can migrate data from a 32-bit server to a 64-bit server by replacing the binary.
-
Run dbcc checks (checkdb, checkalloc, checkcatalog and checkstorage)
on all databases in the 32-bit Adaptive Server to ensure they
are error free.
-
Copy the files for the 64-bit Adaptive
Server into a new directory.
-
Shut down the 32-bit server.
-
Copy the interfaces file and the
configuration file from the 32-bit $SYBASE directory
to the 64-bit $SYBASE directory.
-
Copy the 32-bit $SYBASE/$SYBASE_ASE/install/RUN_<server> file
to the equivalent 64-bit $SYBASE/$SYBASE_ASE/install directory.
-
Edit the RUN_server file
to reflect the new location of the interfaces, configuration,
and log files.
-
Remove all references to the 32-bit $SYBASE directories
from your $PATH definition.
-
Change to the 64-bit $SYBASE directory
and source the SYBASE.csh script (C shell).
-
Change to the 64-bit $SYBASE/$SYBASE_ASE/install directory
and execute:
startserver -f
RUN_server
-
After the 64-bit server starts, run installmaster, installmodel,
and instmsgs.ebf.
-
If you used dbccdb for dbcc
checkstorage, run installdbccdb.
This re-creates tables in the dbccdb. This may cause you to loose data.
-
Drop and re-create the compiled objects, such as
stored procedures, triggers, views, and defaults.
-
If you have partitioned tables, update partition statistics.
-
Run dbcc again on all databases to
verify that they run cleanly.