DTM Schema Reporter is an easy-to-use tool that helps to document your database schema. The user should make a few simple steps to create SQL schema documentation with this reporting tool. For default settings, only three mandatory steps are required. Get your schema documentation within seconds!
| Step | Description |
|---|---|
| Connecting to database | The reporting tool uses life connection to get information about schema objects like tables, views, triggers, procedures, relationships, etc from the database. More information about connection options. |
| Selecting database objects optional, all objects by default |
This step helps the user to select objects which will be included in the output SQL schema documentation. The user can add or remove classes of objects (all views, for example) as well as individual objects to the report. More information about objects selection. |
| Annotating optional, the program will extract notes from the database by default |
The program allows users to add a comment to each database object. These annotations will be included into the output database schema report. The program can extract comments from the database of the most popular DBMS like Microsoft SQL Server, Oracle or DB2 automatically. This feature makes your SQL schema documentation more visual. |
| Report file name and output format selection | The user should specify a file name in which the SQL schema documentation will be stored. The user can select one of the following database schema report formats: RTF (Microsoft Word compatible), HTML, XML, Windows HTML Help (.CHM), PDF, Excel, or plain text. |
| The project execution | The SQL schema documentation will be created after the user press Run button. Also, this SQL documentation software supports command line mode for predefined project execution. |