![]() To see your documentation, open the index.html file. Aqua Data Studio generates HTML files and compresses it to zip file, so you need to decompress it to continue. In the new window select path to save your documentation. Generate HTML Report option in ER Modeler To do this, select Tools -> Generate HTML Report from toolbar. Now we are able to generate HTML documentation. Renaming sheet in ER Modeler Generating Report from ER Diagram In the next step, you can select database, schema, object types and objects documentation should include. In the pop-up window select database instance which documentation you want. Rename Untitled 2 sheet to appropriate by right click and selecting Rename Sheet. To generate documentation select Tools -> Import Database from toolbar. You should then see the generated ER diagram in your workspace, but without a name, and one blank ER diagram sheet.ĭelete Untitled 1 sheet by right click on it and selecting Delete Sheet. Make sure to check Include Comments.Ĭlick the Next button to start generation process. In the next step, you can select database, schema, object types and objects documentation should include. The ER Diagram Generator uses the fully-featured Entity Relationship (ER) Modeler to create saveable, editable and exportable. To generate documentation select Tools -> Import Database from toolbar. Next new window will appear with blank workspace, where you can create your own ERD. In the new window, you must select your database type and its version. ![]() Compare schema, data, query results, files, and folders. Create visualizations and dashboards to analyze data with drag-and-drop. View, filter, and edit query results in Excel-like grid with copy-and-paste. Easily develop, execute, and share SQL statements. Use convenient import and export wizards to quickly select. Import and Export Data Import and export data of different formats to and from databases, tables, objects, and files. You can also create a new ER Model by selecting from toolbar ER Modeler -> New or File -> New -> ER Model.Ĭreating a new ER Model in Aqua Data Studio Use a single database tool to manage many tasks for numerous data sources. Aqua Data Studio is the best database IDE and visual analytics tool for database developers, database administrators (DBAs), and data and business analysts. Here you can select to generate documentation for all schemas by selecting in Schema field option.Ĭlick Next button to generate ER Diagram.Ĭlick here to generate documentation Option 2: ER Modeler Make sure to check the Include Comments option to have your comments in the documentation. In the new window, you can specify what objects your documentation should contain. Right-click on any element which belongs to that schema/database and select Tools -> ER Diagram Generator from the context menu.ĮR Diagram Generator in servers panel context menu 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). The Export to Excel dialog will display a message about highlighted cells exporting.This tutorial will show you how to generate database documentation using Aqua Data Studio.įirst, you will need an ER diagram for documentation - there are two ways to do it: Option 1: Generate option When in the View Data window, select the records you want to export to Excel. The process of exporting selected records is same as exporting complete view data. Pricing for the Standard Edition starts at 499 for one user. ![]() A: All unstable behavior is caused by 1 of 3 things: 1) outdated video drivers, 2) incorrect Java Virtual Machine or 3) an incompatible Oracle Client/JDBC mismatch with the use of the Oracle OCI. Standard is ideal for users looking for a good productivity tool to help develop, access, manage and visually analyze relevant business data. Q: Aqua Data Studio is crashing, not responding, or showing other signs of unstable behavior. You can also export selected records to Excel. Aqua Data Studio follows license-based pricing with two main options available: The Standard Edition and Ultimate. ![]() In the View Data window, click the down arrow next to the icon ( ) and then Export to Excel.Ĭhoose to export the column headers and row count.Ĭhoose to replace blank cells representing NULL data by "(null)" text.Ĭhoose to open the exported worksheet immediately after the export process completes.Ĭlick Next, then browse and select a folder where you want to export the worksheet, type a name for the exported Excel file, and then click Export. xlsx formats and works with all 26 databases that Aqua Data Studio supports. The Excel import tool also examines your Excel file and automatically generates intelligent data mappings. Alternatively, if you want to export summarized or underlying data of a particular data point, then hover your mouse on a data point, and then on the tooltip, click. There is no longer a need to first export your Excel data into csv format and then import one csv file at a time.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |