Web and SQL Server Migration

Summary

This migration scenario is for Issuetrak 11.0 and above only.  It assumes that you're migrating from old Web and SQL servers to new Web and SQL servers with the latest version of Issuetrak.  You can also follow these steps if you are moving from/to a combined Web/SQL server environment.  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, AD integration and SSO, as applicable).  
  2. Be sure that the new environment meets all of the system requirements, including the installation of software and features.
  3. Download the latest version of Issuetrak from here to your current Web server.
  4. Use the IDM to generate a JSON of the existing Issuetrak instance.  This will provide a snapshot of the instance's current deployment configuration.
  5. Stop the website in IIS.  
  6. Perform a backup of your Issuetrak database.
  7. Take the database offline to prevent any site operations (Task, Services, Issue submissions, and editing).
  8. Copy the database backup to the new SQL server.
  9. Copy the JSON generated in step 4 to the new Web server.
  10. Take a backup of the Attachments and Graphics folders in your Issuetrak web folder.  

Deployment

  1. Restore the backup of your database to the new SQL server.
  2. Download the latest version of Issuetrak from here to your new Web server.  

    The remaining steps are performed on the new Web server.
     
  3. On the new Web server, open the JSON in a text editor.  Notepad++ is recommended for this, as Windows Notepad tends to malform the displayed file contents.  
    1. Make the necessary changes to the JSON to reflect the new hosting environment:  Database server info, web server info, file locations/paths, etc.  
    2. Save the file when this is complete and you've validated the information you entered.
       
  4. Use the IDM to deploy the JSON you just saved.
  5. Confirm that the site comes up as normal.  

    Note: If the new server uses the same hostname as the old web server, then it may be necessary to update your environment's DNS to point to the new web server.  
     
  6. Confirm that you can sign into the site.
  7. Navigate to System Settings and update the Application URL (if applicable).
  8. Navigate to the site's Web folder, then overwrite the Attachments and Graphics folders with the backups you took from the old site.  
  9. Confirm that the features of your site are working properly (IEM, OEM, AD integration and SSO, as applicable).  

    Note: It may be necessary to create firewall exceptions for the new web server in order for these features to work.
     
  10. Make sure that the appropriate permissions are set for the Attachments folder location, and set size limits appropriate for your site.  See KB 1578 and KB 1696, respectively, for more information.  
  11. If SSL is used (as Issuetrak recommends), make sure to import the appropriate SSL certificate from the old Web server and configure IIS to use its thumbprint for the site's SSL binding.  
  12. If you used the Issuetrak API with the old Web server, test the accessibility of the API with the new Web server.  


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/.