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


Please sign in to leave a comment.

** Aginity, Inc.’s Provision of Scripts and Similar Materials at Help Desk Center. For the convenience of Aginity Amp™ clients, we provide code snippets, scripts and similar materials at this Help Desk Center. Such materials are reference materials provided for illustration purposes only. These are intended to serve as an example for self-service clients and are generally geared to respond to common questions asked by similar clients. Such materials constitute Aginity’s intellectual property. Aginity Amp clients and their authorized users are permitted to use these materials in connection with their software license and/or subscription of Aginity Amp. Nothing herein shall limit Aginity’s right to use, develop, enhance, modify or market any of these materials as part of its business. These materials are not formally supported by Aginity or its affiliates. Usage of these materials does not guarantee any specific results, uptime, performance or error-free operation. Aginity disclaims all warranties of any kind, whether express, implied, statutory or otherwise, including any implied warranty of merchantability or fitness for a particular purpose.

Powered by Zendesk