This module allows you to register the connection strings to the database, which will later be used for the deployment or update of a database.

Steps to register a connection string:

1. Click the New.
2. Select the database provider at the top of the screen. The available options are:

• SqlServer
  1. Name to identify the connection.
  2. Record connection data:
     Enter the necessary information: database name, server name, IP address, username, and password.
  3. Click the Save (save).

Test the connection

To test the connection and make sure it’s correct, click the Test. You will receive an alert indicating whether or not the connection could be established.

Edit or delete a connection string

If after saving you want to edit or delete a string, right-click on the item in the list and select the corresponding option.

Important Notes

⚐ Note:

• The database must exist previously, i.e., it must have been created in the instance where it is to be deployed.
• The application is only responsible for creating and/or updating the schema.

⚐ Note:
If you want to apply the strings to installed apps, select the string and click the Apply (apply) located at the bottom right or via the context menu. A dialog box will open with the list of applications and services available on that computer. Select them and click Apply (apply).

⚐ Note:
If you want to deploy or update the databases, select the string and click the Update (update) located at the bottom right or through the context menu.

Steps to update the database:

1. Select the connection string and click the Update (update).
2. The window will open Update Database. Here you will find the following controls:

• Current Version- Displays the version currently installed in the database. If no version is installed, it is displayed as No version.
• Package Type: selector that allows you to choose the type of package to run. The available options are:

 -  **Version**: Full version update. This is the default. The package combo will display all available versions with the installed version preselected.
 -  **Hotfix**: Specific fixes applicable to an installed version. They have a dependency version.
 -  **PostInstall**: Scripts that do not require additional dependencies. They can be run on any installed database version. The combo will display the available PostInstall packages.    -  **Package Combo**- Lists the available packages according to the selected type.    -  **Refresh**- Updates the current version read from the database.    -  **Update**- Runs the deployment with the selected package. 3.  Select the type of package you want to run. The package combo will automatically update showing the options available for that type. 4.  Select the package in the combo and click the **Update** (update).

⚐ Note:
When you run a type package Hotfix or PostInstall, the application will ask for an explicit confirmation before proceeding, indicating the type and version of the selected package.

The update information log shows step-by-step the actions that are being executed and any possible errors that may arise.

⚐ Note:
All errors generated by the application are automatically logged in a file located in the Logs, inside the app’s installation directory.