|
|
|
How does DTM Schema Reporter document database schema?
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 database by default |
The program allows the user to add 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 DBMSs
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. |
Quick DTM Schema Reporter Tour
Sample reports |
|
|
•