SQL Server Migration

This migration scenario is for Issuetrak 11.0 and above only. It assumes that you're migrating an Issuetrak database from one SQL server to another. This is normally done when an old SQL server is about to be decommissioned and its databases are being migrated to a newer platform. This article assumes familiarity with our deployment tools.

Additionally, if you are attempting to migrate a version of Issuetrak older than 11.0, please reach out to Issuetrak Support for assistance.


 

Preparation

  1. Confirm that the site is working properly in its current environment (IEM, OEM, Identity Management / SSO, as applicable).
  2. Be sure that the new SQL server meets all of the system requirements.
  3. Make sure you know your site ID. You can get this from Issuetrak Support.
  4. Download the latest version of Issuetrak from here to your current Web server.
  5. From the Web server, use the IDM to generate a JSON of the existing Issuetrak instance. This will provide a snapshot of the instance's current deployment configuration.
  6. Stop the website in IIS.
  7. Perform a backup of your Issuetrak database.
  8. Take the database offline to prevent any site operations (Task, Services, Issue submissions, and editing).
  9. Restart the website in IIS.

 

Deployment

  1. Restore the backup of your database to the new SQL server.

The subsequent steps are performed on the Web server.

  1. Open the JSON in a text editor. (Notepad++ is recommended for this, as Windows Notepad tends to malform the displayed file contents).
    • Update the Database section of the JSON to reflect the values that apply to the new SQL server.
  2. Use the IDM to deploy the JSON that you just saved by performing the following steps:
    1. Open Issuetrak Deployment Manager.
    2. Click Add Sites for Deployment.
    3. Choose the From a Configuration File option.
    4. Select the JSON that was edited in step 2.
    5. Click the box beside the site > click Deploy. Don't make changes to any of the selected deployment contexts, as it is necessary to re-deploy all contexts.
  3. Confirm that the site comes up as normal.
  4. Confirm that you can sign into the site.
  5. Confirm that the features of your site are working properly (IEM, OEM, Identity Management / SSO, as applicable).

Issuetrak Support will be happy to troubleshoot or assist you. You can contact Support at 888-789-8725 (US & Canada), +1 757-213-1351 (International), support@issuetrak.com or https://support.issuetrak.com/.