Product Home
DTM Schema Reporter Online Documentation
General information
Product profile
Connect
Reports
Report settings
Program settings
Tables selection
Objects selection
Advanced
Report profiles
Command line
ER-model
Definitions loader
Property Editor
Additional information
Database utilities
Licence agreement
Demo and Full versions
Product ordering
Install
Uninstall
Upgrade
Support
Glossary

Product profile

DTM Schema Reporter is a reporting tool for database schema. Schema Reporter allows you to include the following objects in the schema report:

  • Tables (with detailed columns information and dependencies) with optional DDL script (text)
  • Primary and foreign keys
  • Indexes
  • Triggers with type and status (for MS SQL, Oracle and Interbase)
  • Views with optional DDL script (text)
  • Synonyms (if applicable)
  • Stored procedures
  • Rules (for MS SQL Server) with optional DDL script (text)
  • Defaults (for MS SQL Server) with optional DDL script (text)
  • Check constraints (for MS SQL Server)
  • Data types
The Security Report is currently available for Microsoft SQL Server and Oracle only. It supports:
  • Roles
  • Server Roles
  • Users/Logins and groups
  • Permissions by user
  • Permissions by database object
  • You can select one of the following report formats: RTF (Microsoft Word compatible), HTML (three options: single file, set of frames, or one file per object), XML, CHM (Windows HTML Help), PDF, Excel, or plain text.

    DTM Schema Reporter allows you to choose which tables (views, procedures, or synonyms) will be included in the report and to set the objects's order. Moreover, the program allows you to create or edit notes (comments, annotations) for tables, columns, views, synonyms, and procedures; these notes will be included in the report too.

    DTM Schema Reporter is a true Win32 application, known to be compatible with the following operating systems: Windows 98 and ME, Windows 2000 family, Windows XP (Home and Professional), Windows 2003 Server family and Windows Vista. To be able to work with Windows 95 and Windows NT 4.0, you will have to download an additional library set from our site.