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.
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...
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:
5. Click OK.
Now, the connections will be displayed like this:
You can customize Document Categories according to your needs.
To edit a category, click the More button.
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 make it almost impossible for you to confuse source and target databases during synchronization.
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).