We now support Google BigQuery Standard SQL syntax along with several new data types. In addition, we now offer Visual Explain plans for Amazon Redshift and Teradata databases. We are also introducing schema synchronization which enables you to deploy differences from your source schema to your target schema. It is a scalable database management tool worth trying for handling large data sets.įor the Aqua Data Studio version 18.0 release, we have added significant usability and functional enhancements to all our editors. The ER diagram generator allows you to obtain a graphical representation of the database structure, while the integrated query builder helps you generate and execute queries and view results displayed as 2D or 3D charts.Īside from the above, there are more features waiting to be discovered in Aqua Data Studio. The IDE features debugging capabilities and allows you to easily import and export data using the dedicated wizards that can guide you throughout the entire process. The application's feature set is completed by the integrated database administration tools, which enable you to manage instances, connections, sessions or storage capacity, as well as generate server statistical reports. The editor features syntax highlighting, line numbering, auto-complete functionality and suggestions, all meant to significantly ease your work. The integrated schema script generator assists you in creating SQL scripts. You can change or create indexes, users, permissions and procedures, as well as edit the data definition language of a database object. Servers and database schemas are displayed in tree-view, for easier navigation and understanding of the structure.Īqua Data Studio displays data in a structured manner, enabling you to create new tables or easily modify existing ones.
The main advantage of Aqua Data Studio is that it does not limit the number of servers you can connect to, which means that you can work with multiple databases simultaneously. It provides support for multiple types of relational databases, such as MySQL, Microsoft SQL Server, Sybase, Oracle, DB2, Apache Cassandra, Derby and Hive, Informix, MongoDB, PostgreSQL, SQLite and more.
0 kommentar(er)
