Configuration & Connection files

Aqua Data Studio's settings, options, connection files and configurations are designed to be easily backed up, copied and modified. It is possible to transfer all or some of the files which are used for database server and SSH server registrations to another user or another computer. The locations of these files vary based on the Operating System.

Contents

• Application Settings and Configurations
• Database and SSH Server Connection Configurations
• Troubleshooting Missing Connections on Windows
• To copy Server Registrations from one machine to another machine

Application Settings and Configurations

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.

Database and SSH Server Connection Configurations

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 transferring individual files for each server.

Troubleshooting Missing Connections on Windows

If you've suddenly lost all of your registered servers, it's possible that an environment variable for your USERPROFILE changed recently. To check where Aqua Data Studio is looking for your connection files, click on the Schema Browser tree node "Local Database Servers" at the very top of the Schema Browser. At the bottom left of the Main Application window the status bar will indicate the path Aqua Data Studio is currently using for its connection files.

The path Aqua Data Studio uses is automatically picked up from the Windows environment variable named USERPROFILE.  In a command prompt you can type "SET" and see a list of environment variables to double check the value.

You can change what Aqua Data Studio is using for a specific path if you pass this value to the JVM ( where C:\Documents and Settings\username is the location you've discovered for your lost connection files )

-Duser.home=C:\Documents and Settings\username

If you use the datastudio.exe or shortcut link on the desktop, then you can add to the <ADS_INSTALL_FOLDER>\datastudio.ini this line :

vmarg.4=-Duser.home=C:\Documents and Settings\username

You could also copy the contents of the your old .datastudio folder to where Aqua Data Studio currently indicates it is looking for connection files.

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 and clicking Go)

   
   

   Linux

   /home/username/.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.
    
4. Open Aqua Data Studio in the 2^nd machine and all the Server Registrations will be available.
    

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