Requiring that SQL Scripts Be Run Only Against a Full SQL Server
InstallShield 2022
Project:This information applies to the following project types:
Installations that include SQL script support allow end users to run the SQL scripts on Microsoft SQL Server Desktop Engine (MSDE) and on SQL Server Express Edition, by default. If you want end users to be able to run SQL scripts on only a full SQL Server, you can use the SQL Scripts view to configure that for any database connection in your installation.
To prevent your SQL script files from running on target systems that have MSDE or SQL Server Express Edition:
|
1.
|
In the View List under Server Configuration, click SQL Scripts. |
|
2.
|
In the SQL Scripts explorer, click the SQL connection that you want to configure. |
|
3.
|
On the Requirements tab, clear the Allow Installation to Microsoft SQL Server Desktop Engine/SQL Server Express check box. |