This view allows you to create SQL script which allow to manipulate SQL databases on the target system. The provided functionality is designed to support SQL database management only. Other database types have to be manipulated by individual custom action measures.
|
Note: Another view of the Visual Designer, SQL databases, provides the management functions to establish connections to SQL database objects which may be manipulated by the SQL script object handled within this view. Identifying the target database for SQL script execution is only possible, if a database object itself has been provided with connection information before. |
Since database handling is not part of the MSI Standard, RayPack utilized special Installer database tables to manage SQL script information until a package is built from the project:
•RPSqlScript - Contains basic data about SQL scripts
•RPSqlReplace - Contains information about search and replace procedures for SQL scripts
If these tables have not been present within the current packaging project before, they are automatically added with the first SQL script object created within the project. Please refer to the section about Custom RayPack installer database tables for further details and table specifications.
The SQL Scripts view is separated into two main areas:
•A list of already available SQL script objects on the left-hand side
This list is grouped by the SQL databases the scripts operate on. With a click on the arrow icon in front of the database group header it is possible to expand and collapse the script list group.
•A details pane for viewing and editing the properties of already existing SQL script objects at the right-hand side
To access the Installer database counterpart of an SQL script item, users have to right-click its list object, and select Go to row from the context menu. The database table RPSqlScript is loaded, with a highlight set on the matching data row.
Standard SQL Script Management Procedures
Common management procedures for SQL script objects are described within the following topics: