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 Customizations and Server Registrations
• Database and SSH Server Connection Configurations
• Troubleshooting Missing Connections on Windows
• To copy Server Registrations from one machine to another machine
• Migrating Aqua Data Studio from one computer to another computer

Application Customizations and Server Registrations

Aqua Data Studio stores all application customizations and server registrations in the [USER_HOME]\.datastudio directory. [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, Windows 7 and Windows 8.1 = C:\Users\USER_HOME\.datastudio
Linux = /home/USER_HOME/.datastudio
OSX = /Users/USER_HOME/.datastudio

The user may easily backup all application customizations and server registrations by copying the full contents of the .datastudio directory to an external storage device.

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 transfering 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, Windows 7 and Windows 8.1

   '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.

Migrating Aqua Data Studio from one computer to another computer

1. Copy your user configuration files from the old machine to the new machine.

1. Copy your [USER_HOME]\.datastudio directory. Copying this directory to a new computer copies all of your current ADS customizations and server registrations.
2. Check File > Options > General > History to find where SQL History and SQL Archive files are stored. If these directories are outside your ".datastudio" directory, copy these directories to the new computer.

2. Run and activate an Evaluation of Aqua Data Studio on your new computer.

3. Go to File > Options > General > History and make sure your SQL History and SQL Archive point to the correct folder paths.

License Information: Make sure you've got a copy of your registration email with your license information easily accessible. Remember that "Company Name" spelling, case, spaces and punctuation need to be used EXACTLY as they appear in the registration email when entered into the License dialog with no extra spaces before or after. It's best to copy this information directly from the registration email then paste it into the License dialog.

4. Deactivate your previous computer's instance of Aqua Data Studio from Help > License.

5. Activate your new instance of Aqua Data Studio on your new computer from Help > License