Migrate data from a 32-bit server to a 64-bit server
by replacing the binary.
- In the 32-bit SAP ASE, run dbcc checks (checkdb, checkalloc, checkcatalog, and checkstorage) on all databases in the 32-bit SAP ASE to ensure that
they are error free.
- Copy the files for the 64-bit SAP ASE 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/bin 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 lose 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.