Aqua Data Studio Changelog

What's new in Aqua Data Studio 15.0.0

Oct 16, 2014
  • 15.0 adds native support for MongoDB, Apache Cassandra, Apache Hive, Microsoft SQL Database (Azure) databases along with a full Git Client and other enhancements.

New in Aqua Data Studio 14.0.8 (Jan 11, 2014)

  • Bug fixes:
  • General: Drag and drop columns from Schema Browser appends datatype
  • Print Preview: Dialog box appears with no paper source selected
  • Other changes:
  • Unbundling Teradata Aster driver

New in Aqua Data Studio 14.0.0 (Oct 17, 2013)

  • For our Aqua Data Studio 14.0 release, we've added native support for three NoSQL databases, MongoDB, Apache Hive and Apache Cassandra and for Microsoft's cloud-based database, SQL Database (Azure). We've also introduced MongoShell, a command line shell for MongoDB which places an interactive javascript mongo shell directly in Aqua Data Studio. Our Git support is vastly improved with the inclusion of a full Git Client that offers complete support for most Git operations in an easy-to-use UI. Additional enhancements include connection clustering, which allows you to use a single registered server to access multiple PostgreSQL (or Teradata Aster or Greenplum or Netezza or ParAccel) databases, dramatic performance improvements for Table Data Editor and Sybase import, support for Sybase IQ 16, Oracle 12c, Teradata Aster Database 5.0, Teradata Database 14.0, ParAccel 4.0, MySQL 5.6, SQLite 3.7.15 and Apache Derby 10.10.1 and much more.

New in Aqua Data Studio 13.0 (Apr 23, 2013)

  • This release adds native support for high-end databases such as Vertica from Hewlett-Packard and Greenplum from EMC, as well as the embedded database SQLite for Android.
  • It also extends support to new database versions including Sybase ASE 15.7 and Sybase IQ 15.4, as well as full support for MySQL 5.5, DB2 z/OS 10, and Netezza 7.

New in Aqua Data Studio 12.0 (Oct 22, 2012)

  • Automate your interaction with databases
  • Enhanced MS SQL Server Support
  • Latest Database Drivers
  • Lightning Fast
  • Manage and Scale Your Connections
  • Breaking the 65k Limit
  • Subversion (SVN) 1.7 Support
  • A brand new visual editing style
  • A more feature rich editor
  • Searchable options framework

New in Aqua Data Studio 11.0 (May 1, 2012)

  • This version adds support for the ParAccel Analytic Database, SQL Server 2012, SQL Log Capture Tool, SSH Browser for ProcFS on Unix machines, and many other enhancements to the ER Modeler and the application in general.

New in Aqua Data Studio 10.0 (Sep 27, 2011)

  • This version added a secure shell (SSH) environment, Perforce and Git version control support, autosave workspaces, shortcut toolbar enhancements, a multithreaded UI, an integrated compression tool and PDF viewer, import and export tool performance enhancements and throttling, OS file MIME type integration, and Excel 2007 support.

New in Aqua Data Studio 9.0 (Oct 5, 2010)

  • New features include a script development IDE, including a JavaScript editor and debugger for writing scripts to automate the functionality of the application using the new Open APIs, which are composed of 20 API packages ranging from archiving and charting to version control.
  • Full native support was added for the Netezza Data Warehousing database.
  • Many Chart package enhancements were made, including new World Map Chart.
  • The DDL script generation of Table and Index partitioning information is supportsed for all databases supporting partitioning.

New in Aqua Data Studio 8.0.0 (Oct 14, 2009)

  • Version 8.0 of Aqua Data Studio now includes improved memory optimization methods than previous versions. One of these techniques is a memory compression method for optimizing resultsets which includes redundant data such as numeric data. Querying for large results in data warehousing environments with large quantities of numeric data will yield dramatic memory reductions. Long term use of Aqua Data Studio in these environments will keep memory usage low and in turn keep performance of the application high. The optimizations are most apparent in the Query Analyzer, Query Builder, Saving Results and Exporting of data.
  • Below are simple examples of a single query on two different types of result sets. One is of redundant numeric and text data, and the other is non-redundant data. The memory optimizations depend on the datasets, but these examples show some relative numbers which can be used to compare optimizations on different datasets.
  • Version 8.0 uses less memory than its predecessors on queries with large resultsets of "redundant" data in the Grid results. Older versions require 220% | 455% more memory.
  • Version 8.0 uses less memory than its predecessors on queries with large resultsets of "non-redundant" data in the Grid results. Older versions require 12% | 64% more memory.
  • Version 8.0 uses less memory than its predecessors on queries with large resultsets of "redundant" data in the Text and Grid results. Older versions require 24% | 97% more memory.
  • Version 8.0 uses less memory than its predecessors on queries with large resultsets of "non-redundant" data in the Text and Grid results. Older versions require 17% | 20% more memory.

New in Aqua Data Studio 7.5.0 (Apr 27, 2009)

  • Memory Optimizations
  • Reduced Memory Footprint – now, Aqua Data Studio uses less memory(30% to 40% less) than previous versions at startup and when retrieving results of more than 65,000 rows. Learn more »
  • New & Enhanced Editors
  • New Java and JavaScript Editors – edit JavaScript and Java with syntax highlighting and all of the other features you get from Aqua Data Studio's HTML, SQL, XML and text editors. Learn more »
  • Enhanced clipboard, Bookmarks, Find and Replace allow you to copy source code and keep its syntax highlighting, navigate through documents with user-defined bookmarks, as well as find and replace with escape characters. Learn more »
  • New & Enhanced Charts
  • New charting tools have been added to include more features developers and analysts need. You now have more control when manipulating the visualization of data including Clustered Column Charts, Stacked Column Charts, Clustered Bar Charts, Stacked Bar Charts and Stacked Line Charts. Columns in a column chart can now be swapped out with different basic shapes like cones and pyramids. Just like ADS 7.0, all options are scriptable and include support for pivot charts. Learn more »
  • Subversion 1.5 Support
  • Subversion (SVN) 1.5 support is built into Aqua Data Studio 7.5, and ready for use with your preexisting Subversion 1.5 installations. We've even included a Relocate feature. Learn more »
  • File Search Tool
  • We’ve added a powerful new File Search Tool into Aqua Data Studio 7.5 for use with your scripts directory and version control repositories. Use it to find, sort and filter files by their content, filename and more. You can include/exclude file types in your search and even search with regular expressions. Learn more »
  • Visual Editing Enhancements
  • Aqua Data Studio 7.5 expands Visual Editing support to allow the visual renaming of schema objects. Learn more »
  • ER Modeler Enhancements
  • The Entity-Relationship (ER) Modeler that is as powerful as even the best standalone database diagramming tools, now allows objects within an ER Model to be renamed. Relationship connectors can be rerouted within diagrams. Learn more »
  • DBA Tools Enhancements
  • The Storage Manager has been greatly enhanced for Oracle, DB2, Microsoft SQL Server, Sybase and MySQL for tuning and monitoring of database storage. ADS 7.5 has enhanced views for Database Size, Table Size and Index Size. Now, DBAs can quickly visually evaluate storage issues for database tuning and performance enhancement.

New in Aqua Data Studio 7.0.0 (Oct 14, 2008)

  • This release has a new ER modeler, MS SQL Server debugger, DB2 for LUW debugger, DB2 for LUW DBA tools, MySQL DBA tools, and localization to 11 languages.
  • It has an enhanced charts toolkit for grids and pivot grids, multiple selection scripting, quick filtering and sorting, Apache Derby support, DB2 for iSeries support, and more.