How to Edit Connection Profiles in VDM

Trouble Viewing Images? Right-click on any image and select "Open in new tab" to view a larger version. You can also zoom in using Ctrl + Mouse Wheel for easier readability.

Article Goal

This article outlines the step-by-step process for editing existing database connection profiles in VDM using the Connection Profile Wizard.

What Is a Connection Profile?

A Connection Profile is a saved configuration that enables VDM to connect to a database. It stores key information such as the connection type, server address, credentials, and schema settings.

Why Edit a Connection Profile?

You may need to edit a connection profile to:

• Update login credentials (username and password)
• Modify server names or IP addresses
• Change database names or schemas
• Enable or disable prefixing, special character support, or other settings

Keeping your connection profiles up to date ensures smooth and secure access to your databases.

Steps to Edit Existing Connection Profiles

Step 1: Open the Edit Connection Option

You can access the Edit tool in two ways:

• Go to the Database tab and click Edit - (Figure 1)
• In the Tables/Fields section, right-click the desired connection profile and select Edit - (Figure 2)

Figure 1: This opens the list of existing connection profiles available for editing. Select the connection profile you want to modify.

Figure 2: This provides a quick way to access the edit screen directly, without using the ribbon menu.

Step 2: Use the Connection Profile Wizard

After selecting a profile to edit, the Connection Profile Wizard will launch with the current settings pre-filled.

You can now update:

• Connection Type for the database and Prefix Options
• Connection Information (Server, Instance, Database, Username, Password, Encrypt Connection, Trust Server Certificate, and Trusted Connection)
• Options (Profile Name and Selected Schemas)

Click Next to move through each step and review or adjust settings as needed.

Step 3: Save Your Changes

After completing your updates:

• Click Finish to save the edited connection profile
• Click Load All from the Database ribbon to refresh available connections and confirm the changes

Article Summary

This article explains how to edit an existing connection profile in VDM using the Connection Profile Wizard. Editing a profile allows users to update key details such as login credentials, server information, database names, and other configuration settings.

There are two ways to start the edit process: by selecting Edit from the Database ribbon or by right-clicking a connection profile and choosing Edit from the context menu. The wizard will open with the current settings pre-populated, making it easy to review and update. After completing your changes, click Finish, then use Load All to refresh connections and apply the updates.