DTM Database Content Analyzer

DTM Database Content Analyzer is an effective and useful software solution created to help you obtain various sets of statistics concerning the information comprised by your databases, supporting Microsoft Access, SQL Server, Oracle and others.

Before you can get started in generating the reports that you need, you have to connect to your database, using the provided wizard.

DTM Database Content Analyzer supports ‘Direct Connections’, ‘Desktop Files’, ‘Data Sources’, ‘File DSNs’ or ‘OLE DB Connection, depending on whichever you prefer working with.

For each of these options, you will need to provide the necessary details, for instance the server name, authentication credentials, source location of database files, along with other information.

Once the connection is established, you can choose a destination folder for your report, opting between HTML5 and HTML4 format. You can sort the information by size or by name, as well as decide whether to include a table of contents and a header into your file.

From the ‘Database Objects’ tab, you can manually select the tables and columns that you want to work with, by checking their corresponding boxes. The ‘Report Options’ section enables you to skip empty tables.

Finally, you can press the ‘Run’ button, which will output a ‘General Report’, or you can choose to generate a ‘Database Size’, ‘Value Frequency’, ‘Extended Statistics’, ‘Cluster Finder’ or ‘Data Anomalies Report’. When complete, it can automatically open in your default web browser.

To sum it up, DTM Database Content Analyzer is a useful and intuitive application that can successfully assist you in obtaining detailed reports about the contents, size, frequency or anomalies in your databases, all while requiring a minimal level of effort from you.