DB Tools

The database view tool is useful for configuring solutions and troubleshooting data issues. You can use this feature to:

Inspect database content and view the contents of tables
Run SQL queries to directly retrieve specific information
Display record counts to determine the number of records in each table

Consultants and support teams can leverage this tool to assist customers in identifying missing data and investigating the root cause of problems by examining the database contents.

You can enable this feature in Setup > Settings > Logging > Special settings and then specify the value 1 on EnableDBTool.

Note: You must have administration rights to access this feature.

From the menu, select Data Administration > DB Tools.
On M3DmpDBTool, select Edit > New Query to open a new SQL Query.
On SQLForm, users can copy and export the result of the query. Select from any of these actions:

Copy

Select this option to copy the contents from the selected queries.

Export

Select this option to export the contents from the selected queries. A prompt is displayed to ask for the location where the CSV file is saved.

Run

Select this option to run the SQL query specified.

A Copy option is also available on the grid to copy the highlighted records including the headers.
On M3DmpDBTool, select File > Export. Specify this information:

Table List

Select this option to export the list of the tables to a file.

Selected Table

Select this option to export a table with content to a file.
On M3DmpDBTool, select Settings > Show Recordcount to display the number of records existing in each table.