Versions Compared

Key

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

...

  • On the Aqua Data Studio menu bar Server > Register Server
  • Right-click in the Schema Browser > Register Server.
  • On the Aqua Data Studio Toolbar, click Image Removed Image Added.
  • Press Insert key on Windows. 

...

Register a Server in Aqua Data Studio 

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

Launch Register ServerProvide Server DetailsServer appears in the
Local Database Servers Node

...

  1. Launch the Register Server dialog.
  2. In the Register Server dialog, select the RDBMS driver, provide the server details, authentication details, and location information, click Test Connection, and then click Save
  3. After the server is successfully registered, it appears in the Local Databases Servers node. You can now Connect to the Server and view its schema objects. 

...

In Aqua Data Studio, you can add registered servers directly to the server node. However, you can also create server groups and register servers to those groups. You can even create subgroups within a group.

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

Launch New Server GroupProvide Group NameLaunch Register ServerProvide Server DetailsServer appears in the
Local Database Servers Node

...

  • Ensure that you have selected the correct RDBMS Driver initially.
  • Check the username and password. Most problems are solved if the authentication information is correct.
  • Make sure that the Database Server to which you are trying to connect Aqua Data Studio Client is up and running.
  • Perform connection diagnostics by clicking Test Connection in the dialog. You will get to see detailed information on the connection and offer helpful tips on what may cause problems with your server registration. The Test Connection dialog contains a direct link to the documentation for the selected JDBC driver for that connection type, a Copy message and detail button, and a view details button. If you need to get in touch with AquaFold about a specific connection issue, click the Copy message and detail button and include this information when contacting AquaFold Support.

    Image RemovedImage Added

Info

The title at the top of the Register Server, Edit Server, and Server Properties dialogs indicate the RDBMS driver (the server type) in brackets, followed by a hyphen and the connection name in parenthesis to assist in troubleshooting. If you are not sure what connection type you are using, look at the title text. For example, a connection to an Oracle 11g server, with the name "My Connection," would appear as [Oracle 9i/10g/11g] - [My Connection].

Edit Server Properties

Image RemovedImage Added

Image RemovedImage Added

Locate & Right-Click
Server > Server Properties
Edit the Server Properties

...

  1. Locate the server in the Server Browser.
  2. Right-click the server and then choose Server Properties. Alternatively, select the server you want to edit and then use the CTRL/Command + SHIFT + P keyboard combination.
  3. In the Edit Server Properties dialog, make the required changes and then click Save

Register a Server Clone

Image RemovedImage Added

Image RemovedImage Added

Locate & Right-Click
Server for Cloning
Type a New Name for
the Clone Server

...

Info

To share or copy registered server connections for use on another computer, see Configuration & Connection Files.

Connect to a Server

Image RemovedImage Added

Image RemovedImage Added

Locate & Right-Click
Server > Connect
Server is Successfully
Connected

...

  1. Locate the server in the Server Browser
  2. Right-click the server and select Connect. Alternatively, select the server you want to connect to and then use the CTRL + INSERT keyboard combination. On a successful connection, the icon changes to a green triangle overlay icon. You can expand the tree node to view the schema objects. Numerous tools like Query Analyzer, Query Builder, and ER Modeler become available to assist with your operations.

Disconnect from a Server

Image RemovedImage Added

Image RemovedImage Added

Locate & Right-Click
Server > Disconnect
Server is Successfully
Disconnected

...

  1. Locate the server in the Server Browser
  2. Right-click the server and then choose Disconnect. Alternatively, you can select the server you want to disconnect and use the keyboard combination CTRL + DELETE. The icon is changed from the green color, and the tree node is collapsed.

Delete a Server

Image RemovedImage Added

Image RemovedImage Added

Locate & Right-Click
Server > Unregister Server
Confirm Your Action

...