Easily find issues by searching: #<Issue ID>
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam
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.
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.
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.
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.
'Documents and Settings\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)
Passwords are not copied, as they are encrypted during creation. They must be reentered once the connections are moved to the second computer.
1. Copy your user configuration files from the old machine to the new machine.
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