DTM Schema Reporter 1.17.09

DTM Schema Reporter 1.17.09 provides users with an option to create multiple report profiles that significantly simplify data processing. The profiles can be saved and loaded with a few mouse clicks. Another important feature is an option to alter table order in the report and manually add annotations (up to 80 symbols) to the individual tables. DTM Schema Reporter is distributed electronically over the Internet.

DTM Schema Reporter, as the name implies, is a reporting tool for database schema. This utility helps technical writers and database administrators create a report of any complexity level within seconds. And importantly, it supports all common database interfaces, whether it is ODBC, IDAPI, OLE DB or even Oracle Call Interface.

Conveniently, DTM Schema Reporter can create reports in multiple formats, namely RTF (compatible with all Microsoft Word versions), XML, HTML, CHM (Windows HTML Help), PDF, Excel or plain text. This product is very flexible and comes with the set of primary and secondary report profile options, which in turn allows users to select any necessary level of report customization.

Why DTM Schema Reporter

1. Most complete set of supported formats. You can create database schema documentation in RTF (MS Word Compatible), plain text, PDF, CHM (HTML Help), XML or HTML format.
2. Extra reports. Security report with detailed information about accounts, logins and rights to database objects helps a DBA or a security administrator to manage database access more effectively. Statistics on data contained in the database gives your important information about each selected table and fields.
3. Definitions Loader (Professional version only) helps the user to load tables and columns definitions to database.
4. Extended Propery Editor (Professional version only) allows the user to add, modify or demove extended properties for SQL Server objects.

How does DTM Schema Reporter document database schema?

1. 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.
2. Selecting database objects. 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.
3. Annotating. 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.
4. 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.
5. 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.

Major Features:

1. Database independent. You can create schema report for Microsoft SQL Server database as well as for Oracle or for Interbase. The software product supports all common database interfaces: ODBC, IDAPI, OLE DB, or Oracle Call Interface.
2. Functionality. Product allows you to include the following objects to the report: tables (with detailed columns information), views, indexes, foreign keys, triggers (with type and status), procedures, defaults, rules and roles. Moreover, the program helps you to add to report optional DDL statements for database objects.
3. Annotations. You can make your database schema reports more friendly by adding notes for your objects in automatic or manual mode.
4. Customizable. Objects selection support. This SQL documentation tool supports styles and fonts customization for RTF reports as well as CSS-based customization for HTML/CHM schema reports.
5. DTM Schema Reporter is a true Win32 application, supports Windows 98/ME, Windows 2000, Windows XP, Windows 2003 Server, Windows Vista.

Requirements:

• ODBC, OLE DB, IDAPI
• Oracle Call Interface