General Tab

InstallShield 2024 » SQL Scripts View » SQL Connection » SQL Script

Project: The SQL Scripts view is available in the following project types:

•

Basic MSI

•

DIM

•

InstallScript

•

InstallScript MSI

You can configure the following settings on the General tab for a SQL script in the SQL Scripts view.

General Tab Settings for a SQL Script
Setting	Description
SQL Script File Name	Click the ellipsis button (...) next to this setting to browse to the SQL script that your installation will execute at run time.
Select Features the SQL Script Belongs to	Select or clear the check boxes for one or more features that you want to contain the SQL script. Project:For DIM projects—The Merged Feature check box in this pane is selected and disabled when you select a SQL script in this view. When you add a DIM to an installation project, you specify the feature that should contain that DIM.
Component Name	This setting shows the name of the component that contains the SQL script. To move to the Components view and see the component that contains this SQL script, click the hyperlink.
Schema Version	Specify a version number to enable script versioning. For more information on this setting, see Specifying a Version Number for a SQL Script File. Tip:When you specify a number for the Schema Version setting and InstallShield adds the custom InstallShield table for storing the schema version number on the target database, the data is not automatically removed upon uninstallation. Therefore, if you want the installation to be able to roll back the changes, you need to create a custom script upon uninstallation to drop the InstallShield table.
Comments	Enter comments about this SQL script. These comments are not displayed to the end user.