Database Grouping in Workbench

There is a little used tool in Aginity Workbench that allows the user to organize databases visually to make it easier to navigate a database server with multiple databases.  This tool is called “Database Grouping”.

Access this feature with menu “View/Database Grouping”

  • /None – Turns of grouping for the current session
  • /Select – Provides a menu of the groupings available
  • /Manage database groups – Create/configure database groupings

Cool features to note:

  • You can define multiple ways of grouping databases (groupings) and change sets depending on how you want databases grouped for the current task.
  • Database grouping sets are saved as part of the connection configuration (workbench connection dialog box), but if you copy a configuration, all database sets form the original configuration are copied to the new one.
  • Check out the “is Default” check box. If you save a grouping with this selected then whenever you launch workbench and use the current connection configuration your databases will be grouped from the beginning.
  • The “Show all databases” option is really powerful.  It has the obvious effect that it lets you see all databases, even those that are already assigned to a group.  The less obvious effect is you can then add the same database to multiple groups – creating a really flexible organization.
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk