2.2 How to Register a Server (Revision #54)

Registering Servers

Once you have installed Aqua Data Studio you will need to register your servers before you get started. There are three methods of registering servers, all of which launch the Register Server dialog

• You can navigate to the Main Application Menu to Server, then select Register Server
• You can right-click in the Schema Browser to bring up the context menu and select Register Server
• You can also click the Query Analyzer Icon at the top left of the Main Application window

All of these launches 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 "Application: Settings" section for more information on sharing and portability of Aqua Data Studio configurations.

Each section below offers specific notes for the different database types.

How to edit server properties

 
To Edit the Server Properties of an already Registered Server, in Aqua Data Studio :

• Locate the Server in the Server Browser.
• Right Click on the Server - A Popup Menu Appears.
• Click on the Item which displays Server Properties.
  

You can change Server Properties like

• Name.
• Type.
• Tab Color.
• Authentication.
• Location - which includes Host and Port.

You can also edit Filters for Schema and Folders, Advanced Properties and Permissions.

Tip : Using the Keyboard combination "CTRL + SHIFT + P", you may quickly edit Server Properties.

How to register a server clone

Clone - Main Menu	Right click Server	Specify Name

 To create a Server Clone of an already Registered Server, in Aqua Data Studio:

• Locate the Server in the Server Browser.
• Right Click on the Server - A Popup Menu Appears.
• Click on the Item which displays Register Server Clone.
• Once you provide a new name for the clone, a new Server is registered.
  

You can now connect to the newly registered Server and perform Data Manipulations.

Tip : Using the Keyboard combination "SHIFT + INSERT", you may quickly create a Server Clone.