1.9 Configuration & Connection files (Revision #17)

Aqua Data Studio stores all application settings and configurations in the <USER_HOME>\.datastudio directory. Where USER_HOME is the home directory of the current user logged into the Operating System.

Windows XP = C:\Documents and Settings\USER_HOME\.datastudio
Windows Vista and Windows 7 = C:\Users\USER_HOME\.datastudio
Linux = /home/USER_HOME/.datastudio
OSX = /Users/USER_HOME/.datastudio

The user may easily backup user settings by copying the full contents of this directory to an external storage device.

All of the Application's settings within File -> Options are contained within the datastudio.properties file. Copying this file to another machine duplicates all of the current options.

Information on Memory Configuration and how to set the amount of RAM Aqua Data Studio uses is discussed on the Launcher & Memory Configuration page.

All database and ssh server connection configurations are stored in the \.datastudio\connections directory and sub-directories, with a connection file for each server in the appropriate directory. Users may exchange and share server connections by transfering individual files for each server.

To Copy Server Registrations from one machine to another machine :

1. Locate the .datastudio connections folder
   Windows XP: 'Documents and Settings\username\.datastudio'
   Windows Vista and Windows 7: 'Users\username\.datastudio'
   OS X: /Users/username/.datastudio  (It can be accessed directly by using the Finder menu  Go -> "Go to Folder..." [Shift+Command+G]  and entering ~/.datastudio clicking Go)
   Linux: /username/home/.datastudio
    
2. Within the  'connections' folder are any server registrations you have created. If you've made folders to group connections within the schema browser, they show up as directories. Individual server connections appear as files with the file name corresponding to the server name entered in the Server Properties settings during registration. Database connections have the file extension .conn, while SSH Servers have the extension .ssh.
    
3. Copy the 'connections' folder's contents or the specific .conn or .ssh files needed and transfer them to the corresponding .datastudio/connections directory of the 2^nd machine.
    

Open Aqua Data Studio in the 2^nd machine and all the Server Registrations will be available.


 

Note: Passwords are not copied, as they are encrypted during creation. They must be reentered once the connections are moved to the second computer.