Page History
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.
| Table of Contents |
|---|
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.
...
| Info |
|---|
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 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.
...
You could also copy the contents of 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
- 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
- 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.
- 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.
- Open Aqua Data Studio on the 2nd machine and all the Server Registrations will be available.
Passwords are not copied, as they are encrypted during creation. They must be re-entered 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.
...