Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

To add multiple databases from the same registered server to your Query Builder Worksheet, click the triangle at the top of the Data Pane and select [Add Database...] For servers that only allow connection to a single database, but do allow multiple schemas, this menu will display [Add Schema...].

Image Modified

When the [Add Database] Dialog appears you can control-click and multi-select to include as many databases from your current Data Source as you like and click [OK].

Image Modified

Any database that is not set as [Primary]  can can be removed if needed by right-clicking it and selecting [Remove].

Image Modified

To see what Schema your current connection is using, view the bottom left corner of the Query Builder.

Image Modified

Info

You can add additional databases (depending on the server vendor) from a single connected server by clicking the triangle in the Database Pane header and selecting [Add Database]. You cannot add databases from different registered servers in the same Data Pane. You can, however, add multiple databases from the same connection when the server supports cross-database queries. See Multi-Database Query for more.

...

To set one of the other databases as Primary, right-click it and choose [Set Primary]. 

Image Modified

The database you chose now displays the checkmark to indicate it is now used as the Primary.

...

  • Add Database... - Allows adding an additional database from the same server connection you are using. See Adding Multiple Databases to the Data Pane for more.
  • Group By Schema - Enables/disables grouping tables in the Table Pane by Schema (for those databases which support it). See Grouping Tables by Schema below for more.
  • Show System Tables and Views - Hides/Shows System Tables in the Table Pane.
  • Reconnect - Reconnects the current connection. See Reconnecting for more details.
  • Refresh - Refreshes the contents of the Data Pane by retrieving the tables and views from the currently connected server. See Refresh the Query Builder for more details.
  • Close - Closes the current connection, disconnects from the current server, and clears all Panes of content. You will receive a confirmation dialog that warns you closing clears the Query Builder Window of all content.
  • Edit Connection... - Edit the Server Registration properties for the current connection
  • Properties - Displays connection properties for the current server. 

Image Modified

Grouping Tables By Schema in the Table Pane

By default, the Query Builder displays tables in the Table Pane for a Data Source in alphabetical order. When servers support Schemas as database objects, you can configure the Data Pane to display your tables grouped by the Schema they belong to.  Selecting [Connection > Group By Schema]  in in the Menu, or clicking the triangle at the top of the Database Pane and choosing [Group By Schema], will display them this way. When grouping by schema, expand a Schema node in the Table Pane and its contained tables appear as subnodes in the tree.

...

Aqua Data Studio does not sever idle connections but many database server installations are configured to drop connections that have been idle for a set amount of time. Also, many firewalls and network security devices, and OS settings can be configured to drop idle connections. Aqua Data Studio has no way of knowing when this occurs because it relies on a server response to inform it that a connection is closed. If the Query Builder reports that there was an error extracting meta information when you modify items, or if it reports [Invalid state, the Connection object is closed], select [Connection > Reconnect] from the Menu and try again.

...