Page History
Once you have installed Aqua Data Studio, you need to register your servers before you get started. Server Registrations are created, edited, grouped, connected to, and disconnected from most easily through the Schema Browser.
Table of Contents |
---|
Launch the Register Server Dialog
...
...
Launch the Register Server Dialog
There are four methods of registering servers, all of which launch the Register Server dialog where you can provide the server properties for the server you are attempting to connect.
...
Register a Server in Aqua Data Studio
Launch Register Server | Provide Server Details | Server appears in the Local Database Servers Node |
To register a server
- Launch the Register Server dialog.
- 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.
- 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.
Launch New Server Group | Provide Group Name | Launch Register Server | Provide Server Details | Server appears in the Local Database Servers Node |
To create a server group
- Right-click the Local Databases Servers node > New Server Group.
- In the New Server Group Name dialog, type a name for the server group, and then click OK.
- Right-click the server group name and then select Register Server.
- Register the server.
- Expand the server group name to see the registered servers.
...
This table lists database specific information for registering server connections.
Troubleshooting Registrations
Verify Driver Connection | Verify Login Name and Password | Test Connection |
If you face any problem during server registration, there might be a few things that you need to review:
...
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
Locate & Right-Click Server > Server Properties | Edit the Server Properties |
To edit the server properties of an already registered server
- Locate the server in the Server Browser.
- 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.
- In the Edit Server Properties dialog, make the required changes and then click Save.
Register a Server Clone
Locate & Right-Click Server for Cloning | Type a New Name for the Clone Server |
To create a server clone of an already registered server
...
Info |
---|
To share or copy registered server connections for use on another computer, see Configuration & Connection Files. |
Connect to a Server
Locate & Right-Click Server > Connect | Server is Successfully Connected |
To connect to a server
- Locate the server in the Server Browser.
- 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
Locate & Right-Click Server > Disconnect | Server is Successfully Disconnected |
To disconnect from a registered server
- Locate the server in the Server Browser.
- 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
Locate & Right-Click Server > Unregister Server | Confirm Your Action |
To delete a server
- Locate the server in the Server Browser.
- Right-click and then choose Unregister Server. Alternatively, select the server you want to delete and press the Delete key.
- Click Yes to confirm your action. The server is deleted from the Local Database Servers node.
...