dbForge Studio for SQL Server

All-in-One SQL Server GUI Tool

Connection Categories

Overview

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 problem by
associating a certain connection with a color category. Applying the category enables you to see which
connection the current document belongs to.

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

None (by default)

Development

Production

Sandbox

Test

5. Click OK.

Now connections look like this:

Editing Categories

You can customize Document Categories in accordance with your needs.

To edit a category, click the More button.

The Options dialog box opens, where you can change Name, Shape and Color parameters for each category.

To create a new category, click the New Category button.

To delete a category, highlight one and click Delete Category.

To return to default settings, click Reset to Default.

To save changes, click OK.

Using Categories

To demonstrate Document Categories in use, we marked one database as ?Development?,
and the second one as ?Production?.
Now, while working with documents that have similar names but
belong to different connections, we won't be confused, e.g., we won't delete
information from the improper database.

Categories may also be extremely useful while performing comparison and synchronization.
During comparison, you will never confuse source and target databases, and be able
to distinguish source and target records at a glance. Also, you can always make sure that a
comparison report will be saved to a proper place.

Categories make any confusion of source and target databases during synchronization almost impossible.

Summary

The Categories feature in dbForge Studio for SQL Server is meant to simplify the work with
multiple connections and allows distinguishing 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, which is prior to production, as Development (green).

Company

We use cookies to provide you with a better experience on the Devart website. You can read more about our use of cookies in our Cookies Policy.
Click OK to continue browsing the Devart site. Be aware you can disable cookies at any time.