This documentation applies to the 8.1 version of Remedy IT Service Management Suite, which is in "End of Version Support." You will not be able to leave comments.

To view the latest version, select the version from the Product version menu.

Duplicating the production server database for upgrades without overlays

This section describes how to copy the current production server database schema and data to the new staging server.

Back up the production server database

Work with your database administrator responsible for the production environment to create a full backup of the current production BMC Remedy AR System database.

Note

Note the date and time of the backup for future reference. You will use this information in the delta data migration step to determine which data needs to be migrated to the staging server at the end of the upgrade process.

To duplicate production database backup on the staging server

  1. On the staging server, shut down AR System server.
  2. Work with the database administrator responsible for the production environment to restore the database onto the staging server database.
  3. If you are running SQL Server, run the following command in your database:
    sp_changedbowner "ARAdmin"
    Substitute ARAdmin with the appropriate BMC Remedy AR Database Administrator Account.
  4. Change the AR System server name to match the new host. For details, see Changing a server name when using a duplicated or migrated environment.
  5. If you are using the duplicated staging server method, restart the BMC Remedy AR System server and verify that the system is functional.
  6. If you are using the duplicated staging server method, work with the database administrator responsible for the production environment to back up the staging server database.
  7. Run the AR System database consistency checker, and run the health check in the BMC Atrium Core maintenance tool (see below) to verify that your system is running correctly before the upgrade.

To run the CMDB Check

Note

The CMDB health check was introduced in version 7.5. If your staging server runs an earlier version, you can skip this step.

  1. Launch the BMC Atrium Core Maintenance Tool:
    • On Microsoft Windows, go to the <AtriumCoreInstallDir>\atriumcore folder, and double-click the AtriumCoreMaintenanceTool.cmd file.
    • On UNIX, go to the <AtriumCoreInstallDir>/atriumcore/ directory, and launch the AtriumCoreMaintenanceTool.sh file.
  2. Click the Health Check tab, and follow the instructions there.

Related topics

Running the database consistency checker in the BMC Remedy AR System documentation

Where to go from here

After you set up your staging server, review Stage 2 - Upgrade AR System server without overlays present, including the subsections.

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Comments