Provide SQL Scripts for Creating the SQL Database Prior to Installation
Provide a way for a user with elevated SQL credentials to complete the SQL part of the installation prior to another user completing the installation of the executable. Customer Issue: Many customers have restricted access to SQL servers that an installing user would need to complete the installation. Providing scripts for the customer to complete the database creation before the installation means they can review the specific tasks that will be carried out before running the scripts, and they can have a user with existing elevated permissions perform this part of the installation.
Gabriel Michaud-Verreault commented
The person performing the install / upgrade should not necessarily have access to the database, and the DBA should not necessarily have access to the frontend application node.
Another use case, is when there is simply a move of the application service - no need to change the SQL backend.
Additionally, all products should be consistent. AF and PI Vision already provide this functionality, it should be standard across all applications with a SQL backend.
Laurie Dieffenbach commented
To provide more context, it would be ideal if running SQL Scripts was always optional, for any product. In the case that prompted this request, a database upgrade was not necessary, but the installation kit insisted on conducting an upgrade anyway. The account used to run the installation kit doesn’t have the necessary permissions so the install kit had to be cancelled and the upgrade, therefore, failed.
Gonzalo Merciel commented
For everyone interested, you can download the SQL scripts from https://techsupport.osisoft.com/Downloads/File/08cc1c2d-30b0-4626-b33c-9233612b6a1c