This tutorial will show you how to generate database documentation using Aqua Data Studio.
First, you will need an ER diagram for documentation - there are two ways to do it:
Now in the Servers Panel find database/schema which documentation you want (if you want to have all schemas in the documentation you can change it in next step). Right-click on any element which belongs to that schema/database and select Tools -> ER Diagram Generator from the context menu.
ER Diagram Generator in servers panel context menu
In the new window, you can specify what objects your documentation should contain. Make sure to check the Include Comments option to have your comments in the documentation. Here you can select to generate documentation for all schemas by selecting in Schema field < All Schemas > option.
ER Diagram Gererator options
Click Next button to generate ER Diagram.
You can also create a new ER Model by selecting from toolbar ER Modeler -> New or File -> New -> ER Model.
Creating a new ER Model in Aqua Data Studio
In the new window, you must select your database type and its version. Click OK.
Next new window will appear with blank workspace, where you can create your own ERD. But this is not our goal. To generate documentation select Tools -> Import Database from toolbar.
Importing database in ER Modeler
In the pop-up window select database instance which documentation you want.
In the next step, you can select database, schema, object types and objects documentation should include. Make sure to check Include Comments.
Import options in ER Modeler
Click the Next button to start generation process. You should then see the generated ER diagram in your workspace, but without a name, and one blank ER diagram sheet.
ER Modeler after import
Delete Untitled 1 sheet by right click on it and selecting Delete Sheet.
Removing sheet for workspace
Rename Untitled 2 sheet to appropriate by right click and selecting Rename Sheet.
Renaming sheet in ER Modeler
Now we are able to generate HTML documentation. To do this, select Tools -> Generate HTML Report from toolbar.
Generate HTML Report option in ER Modeler
In the new window select path to save your documentation. Aqua Data Studio generates HTML files and compresses it to zip file, so you need to decompress it to continue. To see your documentation, open the index.html file.
Sample generated documentation