When you reverse engineer a database, you can set a trace file to record the database queries. You can analyze the queries that are 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. Saving trace files is a best practice as these files help in diagnosing problems, if any.
Follow these steps:
The Options dialog opens.
Save the queries that are used to retrieve information from the database. The time elapsed in retrieving is also recorded, which helps in diagnosing problems, if any. The SQL trace files are saved under the name ERwin SQL Trace <date> <time>.txt.
Saves the actual syntax that you have used to create views and materialized views in your database. The SQL trace files are saved under the name ERwin View Trace <date> <time>.sql.
Displays the default location for saved trace files. You can browse for and can change the default location.
The trace file options are saved, and the Options dialog closes.
|
Copyright © 2015 CA Technologies.
All rights reserved.
|
|