Database Diagrams, ER Models, ER Diagrams, Entity Relationship Diagrams and Database Design in Aqua Data Studio

Entity Relationship (ER) Modeler, Database Diagrams and Database Design - Aqua Data Studio

Aqua Data Studio offers an Entity Relationship (ER) Modeler for all major RDBMSes. It's a full-featured Schema Model tool for database administrators and database developers to diagram databases and visualize schema relationships. The Entity Relationship (ER) Modeler, advanced query tools, visual query building tools, schema compare tools and a broad range of features help database developers create ER diagrams and work efficiently and productively. Any database you connect to in Aqua Data Studio can be diagrammed with the ER Modeler!

ER Models and Database Diagrams in Aqua Data Studio

Benefits

Script Database Design Diagrams into Databases: Edit database structures in a database design diagram, modify schema objects, alter entity relationships and then automatically script the changes into a database from the ER model.

Share Database Design: With Aqua Data Studio's built in Subversion (SVN) and CVS clients, share your ER Models and database entity relationships with coworkers so they can collaborate on your database models in version control.

SQL (History) Archive: The SQL History Archive can automatically store every query run (over days, months and years) and can be searched and filtered later for easy reuse of queries. This archive is also extremely useful for auditing purposes (Sarbanes-Oxley Compliance).

Includes Database Administrator Tools For Oracle, DB2, MS SQL Server, Sybase and MySQL

Instance Managers: Provides manageability of the database instance allowing the user to view and modify server parameters and viewing server version information.

Storage Managers: Provides manageability of databases, database devices, storage and dump devices and caches, allowing a user to visualize and maintain storage.

Security Manager: Provides manageability of logins, server roles, users and roles allowing the user to manage permissions, roles and security of databases.

Session Managers: Provides manageability of database sessions including user locks which allow the user to monitor and kill sessions.

and much more!

For Windows, Linux and OS X, Aqua Data Studio's features and capabilities include:

DB2 SQL Debugger
Oracle SQL Debugger
MS SQL Server Debugger
Sybase SQL Debugger
ER Modeler
Visual Editing
Subversion (SVN) client
CVS client
SVN Repository Browser
CVS Repository Browser
Autocompletion across DBs
Server Side Comments
Morph to Delimited List
SQL Formatter
Visual Explain Plan
Procedure/Package Editor
Script Generator
Server Script Generator
Execution Monitor
Explain Diagram
Import Tool
Export Tool
Object Search
Parameterized Scripts
and much more...