Reverse Engineer › Save Database Queries to a Trace File

Save Database Queries to a Trace File

When you reverse engineer a database, you can set a trace file to record the database queries. You can analyze the queries executed against the database during the reverse engineering process. You set options for the trace file in the Diagnostics tab of the Options dialog before starting the reverse engineering process.

To save database queries to a trace file

1. Click Options on the Tools menu.

   The Options dialog opens.

2. Click the Diagnostics Tab and complete the following fields:

   SQL Trace

   Logs database queries into the trace file.

   View Trace

   Logs view statements and materialized view statements used to query the database into the trace file. This option only applies if your target database is Oracle.

   Trace Files

   Displays the default location for saved trace files. You can browse for and change the default location.

3. Click OK.

   The trace file options are saved, and the Options dialog closes.