Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Once you have installed Aqua Data Studio you will 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.
There are three methods of registering servers, all of which launch the Register Server dialog.
All of these launch the Register Server dialog, which lets you fill in the properties of the server you are attempting to connect to.
The properties of any registered server can be viewed and altered by right-clicking on a server in the Schema Browser and selecting "Server Properties."
There are defaults set for the different RDBMSes within the Register Server Dialog, depending on the database vendor and version chosen. In most cases it is good to use these defaults. There is some variation in how different database types are registered and it is important to have the correct drivers. For more information on drivers see the "JDBC Drivers" section.
It is possible to register servers by using a configuration copied from another user. The servers from a copied configuration will populate the schema browser, but passwords will have to be entered within the properties of each one. Passwords do not copy when configurations are duplicated. See the "Configuration & Connection Files" section for more information on sharing and portability of Aqua Data Studio configurations.
|New Server Group||Group Name||Register Server||Enter Server Details||Server Registered||Connect|
To Register a Server :
Select the Database Server you want to connect to and use the keyboard combination "Shift + INSERT" to quickly create a Clone of the Server
Each section below offers more database specific information for registering server connections.
|User name & Password||Click on Ping||Driver|
If you face any problem during Server Registration, there might be a few things which you are doing wrong:
Tick the ’Save Password’ check box and you may quickly connect to a Server without having to type in the authentication every time you Connect.
To Edit the Server Properties of an already Registered Server, in Aqua Data Studio :
You can change Server Properties like
You can also edit Filters for Schema and Folders, Advanced Properties and Permissions.
Using the Keyboard combination "CTRL + SHIFT + P", you may quickly edit Server Properties.
|Clone - Main Menu||Right click Server||Specify Name|
To create a Server Clone of an already Registered Server in Aqua Data Studio
You can now connect to the newly registered Server and perform Data Manipulations.
Using the Keyboard combination "SHIFT + INSERT", you may quickly create a Server Clone.
To share or copy registered server connections for use on another computer, see Configuration & Connection Files
|Locate the Server||Select the Database||Popup||Green Icon - Connected|
To Connect a registered Server
Select the Database Server you want to connect to and use the keyboard combination "CTRL + INSERT" to quickly Connect to the Server
|Locate the Server||Right Click - Popup||Disconnected|
To Disconnect a registered Server :
Select the Database Server you want to disconnect and use the keyboard combination "CTRL + DELETE" to quickly Disconnect from the Server