The upgrade procedure for SQL Reporting involves upgrading the databases followed by upgrading the reports. These procedures are detailed in this topic.
Upgrading the Databases
Upgrade 11.9 on the Reporting Server to the latest version
Copy the files 'Setup.defaults' and 'SetupReports.defaults' from the deployed '<product>' folder into the new 'Solutions/<product> folder.
Close any windows (e.g. file explorer) that are using the folder <Prognosis Home>\Server\Configuration\BigDataInsight\<product>.
Failure to do so will result in the upgrade failing.
Start a Command Prompt with 'Run as Administrator' and change to the following setup folder path:
Run the command:
The setup will ask a series of questions that are used to upgrade the SQL Reporting solution. The same settings as used previously should be re-used. These settings are stored in the 'Setup.defaults' file.
Enter the name of the deployment and then press <Enter>. This must match the name of what was previously deployed. The default deployment name is the name of the product (e.g. UC).
Press <Enter> to continue the configuration (using the default option of 'C' to Continue).
Enter the SQL Server instance name on 'SQL Server' (Default: 'Your default instance name') <Enter>.
Enter the Datamart database name (Default: 'Your existing datamart DB') <Enter>.
Enter the Staging database name (Default: 'Your existing staging/source DB') <Enter>.
Press <Enter> to confirm the database upgrade (using the default option of 'U' to Upgrade).
Confirm that you wish to proceed, having created a backup, by entering 'Y'.
Enter 'How many months of data should be kept for reporting' (Default: 'Existing aging') <Enter>.
Enter the nodes to collect from, use comma separated list or use 'default' for all nodes (Default: #AllNodes) <Enter>.
Add the SSIS Server hostname/IP address (Default: 'Your existing SSIS Server')> <Enter>.
Add the SSIS Server instance name on 'SSIS Server' (Default: 'Your default instance name')> <Enter>.
Enter the full path where the SSIS package is going to be deployed (Default: 'Your existing folder on SSIS Server'):> <Enter>.
Enter the login password for the user ('setup user name'):> <your password> <Enter> (twice).
Continue with these settings ? [C]ontinue [M]odify [Q]uit (Default: C)> <Enter>
Next, it will be necessary to follow the steps at the end of the setup process. These must be completed manually, follow the instructions carefully from the setup output:
If instructed, copy the SSIS folder to the SSIS/SQL server (replacing the SSIS directory that used to be on the server) Take careful note of the paths displayed. It will be necessary to copy the deployment SSIS folder from the deployment folder e.g. <Prognosis_Home>\Server\Configuration\BigDataInsight\<product> rather than the setup folder <Prognosis_Home>\Server\Configuration\BigDataInsight\Solutions\<product>
Copy any customized csv files from the deployment folder backup to the following folder path:
If using the SQL Server Agent to schedule the ETL:
a) Re-enable the ETL job that was disabled during the install.
b) Re-configure SQL Reporting to not run the ETL itself. For details see Scheduling the ETL Job via the SQL Server.
Additional Manual Steps
In certain scenarios during an upgrade, there may be a prompt to manually run an ETL.
Choose 'Y' to ensure that all the data from the Staging database is moved into the Datamart database before upgrading.
After the 'Upgrade' steps have been completed, deploy the updated reports by following the process outlined in the Install the SQL Reports on the SSRS Server. When prompted “Overwrite existing reports?” Type 'Y' for Yes.