Page History

...

If you have 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.

Image Modified

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.

...

1. Locate the .datastudio connections folder
   

   Windows XP

   'Documents and Settings\username\.datastudio'

   Image Modified

   Windows Vista, Windows 7 and Windows 8.1

   'Users\username\.datastudio'

   Image Modified

   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)

   Image Modified

   
   Image Modified

   Linux

   /home/username/.datastudio
    

2. Within the  'connections' folder is 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.
   Image Modified
    
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 on the 2^nd machine and all the Server Registrations will be available.
    

...