Staging Deployment

In order to deploy the latest version of OMNINxG from DEV to Staging (omninxg.aspirtek.com) - follow these steps:

• 1. Login to the Staging Server - omninxg.aspirtek.com

  2. Download the latest OMNINEXT database backup from drive.google.com and extract it using 7Zip.

  3. Use SQLBackupAndFTP to restore the BAK file to the OMNINEXT database.

  4. Use @Max SyncUP to restore the OMNI APPs directory from drive.google.com to C:\omni

  5. Restart IIS and test if the application restored correctly.

  6. Download the latest version of the following databases from drive.google.com

     1. OMNINEXT_Reporting

     2. ReportServer

     3. ReportServer_TempDB

  7. Restore these databases using SQLBackupAndFTP

  8. Backup the Encryption Key from the SSRS installation on OMNINXG-DEV and copy it to the Staging Server

  9. Restore the Encryption Key on Staging.

  10. Use the RSMgmtKey command line utility to remove references to omninxg-dev from the SSRS installation on the Staging Server

• • 1. (see: http://darrenmyher.com/2014/02/23/rsreportservernotactivated/)

• 11. Login to the SSRS installation (https://omninxg.aspirtek.com/Reports) - and choose the DataSources folder and modify the datasources to point to the OMNINEXT and OMNINEXT_Reporting databases on Staging.

  12. Verify that the reports are working on the SSRS installation.

  13. Login to https://omninxg.aspirtek.com/omni with host login and browse to the Analytics -> Finance page.

  14. Use Edit Page and modify the Server Settings of the SSRS Module. Remove the reference to omninxg-dev and change it to omninxg.aspirtek.com

See the video below for details of above steps: