Options - Aqua Data Studio 22.1 has configurable options to assist you with all your jobs. Detailed documentation is provided for each. Using the Tools available in Aqua Data Studio 22.1 - Once you have connected to a server, use all the different tools available to automate your most complex tasks, including Query Analyzer, Query Builder, Visual Analytics, Debuggers, Editors, ER Modeler and Version Control. If you still experience problems connecting to your database you should review the JDBC driver and the registration section of the documentation. See step-by-step instructions with screenshots here.Ĭonnecting to a database - Ready to connect? View the sample registration screenshots provided in the gallery for help with your specific database ( registration/screenshots). Simply decompress the downloaded package and run one of the following: datastudio.exe (for Windows), datastudio(.bat/.sh) (for console with your own JVM), datastudio-bundled(.bat/.sh) (for console with bundled JVM), or Aqua Data Studio.app for Mac. Installation - It is simple to install Aqua Data Studio. When working on your own with ADS, you have the. If you experience any download problems or just slow download speeds, please send an email to so that we may upgrade our servers and bandwidth. 4 Aqua Data Studio has a default setting which prefers / and GO as statement separators for SQL statements. Ultimate License - Visit our License page for more information.ĭownloading - You can download the appropriate package for your operating system by logging into the Customer Support Portal or registering for a free trial. What's New In This Release? - Visit our What's New page to find out. Once you have your database query tool up and running, you may continue into the documentation to understand the different features of Aqua Data Studio. Thomas Conrad over 4 years ago in reply to Chris Kingĭid the example that I provided help? It looks like it worked.Welcome to Aqua Data Studio Documentation - Below you will find 6 quick steps to getting you started with Aqua Data Studio. See the attached screenshots as an example.Ĭhris King over 4 years ago in reply to Thomas Conrad Is there a configuration that needs to be set to properly handle UTF8 in Aqua Data Studio? Responseĭo you have the Query Analyzer editor in Aqua Data Studio set to utf8? You can set that in the Query Analyzer window or in the Aqua Data Studio Options menu. We have also followed other help references to add ‘?characterEncoding=utf8’ to the Driver Parameters under Server Properties. We have tested using Workbench to insert and ADS to read, and vice versa. If we try to insert utf8 data into the tables using Aqua Data Studio (18.0.19) then the data is not stored correctly, however it works if passing the same query using MySQL Workbench.įor example the following query using MySQL Workbench works but not using ADS, which will store the data as ‘?’ Select options to ignore rows with all null values or set value to NULL on (null) text. Data importing can be started by selecting Tools->Import Data from the File Menu or right clicking on the table you want to import and selecting Tools->Import Data. ![]() We have a MySQL database which has been created with utf8 character set and unicode collation (CREATE DATABASE dbname DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci), and with table and column definitions also set to utf8. The Aqua Data Studio Import Tool allows users to import data into database table objects.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |