Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

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.

Connections Location Path in Status BarImage RemovedImage Added

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'

    Windows ConnectionsImage RemovedImage Added

    Windows Vista, Windows 7 and Windows 8.1

    'Users\username\.datastudio'

    windows_8_1_connections.pngImage RemovedImage Added

    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 AddedOSX - Go to Folder Image Removed
    OSX Aqua Data Studio - ConenctionsImage RemovedImage Added

    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.
    Connections contentsImage RemovedImage Added
     
  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 2nd machine.
     
  4. Open Aqua Data Studio on the 2nd machine and all the Server Registrations will be available.
     

...