Associating tabs with connections

You can associate tabs with connections using tab coloring, which allows setting custom connection colors for SQL servers and databases that can be assigned to a specific environment for the user to quickly identify which connection a tab is currently using. Schema Compare for SQL Server helps easily label individual servers and databases with specific color codes. The tool highlights tabs as well as status bars of documents.

Coloring for servers

With Schema Compare for SQL Server, you can set a color for a server. It is a good way to separate, for instance, testing and production servers. You can assign a color to a server based on the environment you want associate it with: Development, Production, Sandbox, Test, or None.

Coloring for databases

It is easy to assign a color to an individual database, which delivers even better flexibility.

To configure tab coloring options, go to Tools > Options > Environment > Categories.

1. Under Category Settings, you can add, remove, and modify environments, as well as assign shapes and colors to them using the following options:

  • The default environments are Development, Production, Sandbox, and Test. You can modify them according to your requirements.
  • Click New category icon New Category to set a new environment category.
  • Click Delete category icon Delete Category to remove the environment category.
  • Use the wildcard character (*) to substitute one or more characters in the names of servers and/or databases. The bare asterisk in the Server and Database fields means that the environment category will be assigned to any server or database.

2. Under Environment Categories, you can associate servers and databases with the required environments.

  • Click New color match icon New Color Match to set a new environment category.
  • Click Delete color match icon Delete Color Match to remove the environment category.

Tab coloring

After the setup, all tabs and the SQL document status bars will be labeled with the corresponding colors.

Tab coloring with multiple connections

Want to Find out More?

Overview

Overview

Take a quick tour to learn all about the key benefits delivered by dbForge Schema Compare for MySQL.
Request a demo

Request a demo

If you consider employing the Schema Compare for your business, request a demo to see it in action.
Ready to start using dbForge Schema Compare for MySQL?