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 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.
  2. Copy the files for the 64-bit SAP ASE into a new directory.
  3. Shut down the 32-bit server.
  4. Copy the interfaces file and the configuration file from the 32-bit $SYBASE directory to the 64-bit $SYBASE directory.
  5. Copy the 32-bit $SYBASE/$SYBASE_ASE/install/RUN_server file to the equivalent 64-bit $SYBASE/$SYBASE_ASE/install directory.
  6. Edit the RUN_server file to reflect the new location of the interfaces, configuration, and log files.
  7. Remove all references to the 32-bit $SYBASE directories from your $PATH definition.
  8. Change to the 64-bit $SYBASE directory and source the SYBASE.csh script (C shell).
  9. Change to the 64-bit $SYBASE/$SYBASE_ASE/bin directory and execute:
    startserver -f RUN_server
  10. After the 64-bit server starts, run installmaster, installmodel, and instmsgs.ebf.
  11. If you used dbccdb for dbcc checkstorage, run installdbccdb. This re-creates tables in the dbccdb. This may cause you to lose data.
  12. Drop and re-create the compiled objects, such as stored procedures, triggers, views, and defaults.
  13. If you have partitioned tables, update partition statistics.
  14. Run dbcc again on all databases to verify that they run cleanly.