SQL Connection Categories

When working with dbForge Studio for SQL Server, you may have multiple connections opened simultaneously. Trying to understand which window is related to which connection can be quite difficult. The Document Category feature of dbForge Studio for SQL Server is meant to resolve this issue by providing you with the ability to color the connections and place them in various categories. Categories allow you to see which connection the current document belongs to.

Setting Up The Connection Categories

To assign categories and colors to connections, follow the steps below:

1. In Database Explorer, find the needed connection.

2. Right-click the connection and select Modify Connection...

Modify Connection

3. In the Data Connections Properties dialog box, go to Document Category and click the drop-down arrow.

4. Select a suitable option from the drop-down list. There are five options available, each one marked by a colored geometric object:

  • None (by default)
  • Development
  • Production
  • Sandbox
  • Test
Connection Types

5. Click OK.

Now, the connections will be displayed like this:

Applied Categories

Editing Categories

You can customize Document Categories according to your needs.

To edit a category, click the More button.

More button
  • The Options dialog box opens. Here, you can change the Name, Shape and Color parameters for each category.
  • To create a new category, click the New Category button.
  • To delete a category, highlight it and click Delete Category.
  • To return to the default settings, click Reset to Default.
  • To save the changes, click OK.
Editing Categoris Window

Using Categories

To show Document Categories in action, we marked one database as Development, and the second one as Production. Now, when working with documents that have similar names but belong to different connections, we won't be confused. This can help us avoid deleting information from wrong databases.

Documents with Similar Names

Categories may also be extremely useful when we are performing comparison and synchronization. During comparison, you won't confuse source and target databases and will be able to distinguish source and target records at a glance. Also, you can always make sure that comparison reports will be saved to the proper place.

Categories Shown During Synchronization

Categories make it almost impossible for you to confuse source and target databases during synchronization.

Categories Shown Within Categories Wizard

Summary

The Categories feature in dbForge Studio for SQL Server is meant to simplify the process of working with multiple connections and allows you to distinguish database objects at a glimpse.

If you work with several servers, Categories can help you to differentiate one connection from another, or make sure that a certain database object belongs to a proper server or connection. Categories can also be used to sort SQL documents by groups. For example, you can mark one group as Production (red) and the other one as Development (green).