SQL Databases (Server Configuration)

The SQL Databases page allows you to connect to local or remote database servers and run SQL scripts on them. Absolutely no client software is required on the host machine for the connections, which are carried directly over TCP/IP. In addition, you may use any number of script variables in your connection settings as well as the SQL scripts themselves.

Creating a New Connection

To create a new connection to a SQL server and execute a SQL script, follow these steps:

1. Click the New button.
2. Choose the server type to connect to.
3. Depending on your choice, a MS SQL Server, My SQL, or Oracle Database window appears. Populate the necessary dialog fields for the connection and load your SQL script into the dialog.
4. Click OK to save your changes.

Editing an Existing Connection

To update an existing SQL server connection, or modify the SQL script, follow these steps:

1. Highlight the connection to edit.
2. Click the Edit button.
3. Depending on your connection, a MS SQL Server, My SQL, or Oracle Database window appears. Update the necessary dialog fields for the connection and if necessary modify your SQL script in the dialog.
4. Click OK to save your changes.

Removing an Existing Connection

If you would like to remove a SQL server connection (and its associated SQL script), follow these steps:

1. Highlight the connection to remove.
2. Click the Delete button.

Scripting Details

The two-way integrated IDE emits or updates the underlying setup script every time the visual view is used. If you are using InstallAware scripting in your setups, the following information identifies the changes made by this visual page to your setup script.

Commands Used

This page emits the following types of scripting commands: MS SQL Server, My SQL, Oracle Database. Additional general scripting commands may be emitted.

Commands Required

This page requires the following scripting commands to be already present in your setup script: Apply Install.