Reports Tab¶

How to access the dialog

• Main Menu | Tools | Preferences

• Main Menu | Tools | Generate Scripts | SQL Script for Creating Table, Preferences Button

• Main Menu | Tools | Generate .INT | .INT File from .DAT, Preferences Button

• Filelist dialog, Convert Database Button, Preferences Button

Mertech’s Flex2SQL Database Migration Utility contains a migration report feature. This comprehensive reporting facility gives users a complete picture of the migration process. It is no longer necessary to analyze the migration process on a table-by-table basis.

• Enable Migration Logging: This feature is useful in identifying bad data in the DataFlex database, which might result in incomplete migration. Mertech’s drivers have various levels to define tracing granularity.

• Enable Application Logging: This option sets the registry key to turn on the driver traces to allow you to generate driver level traces while you are running your application.

• Detail Level: Allows you to control how detailed a trace you want the driver to generate. For most data related problems, Error Only is the best option.

  1. Errors Only logs only native SQL error related information and driver identification. No other detailed information is included in the log file. The message(s) are preceded by ‘ERROR’ or ‘WARNING’. This option also minimizes the size of the trace file.

  2. Debug is the default trace level. It includes the previous level’s information in addition to logging all the database calls issued by the application, like FINDs, SAVEs and DELETEs, LOGIN, LOGOUT and the embedded SQL calls. Besides logging these commands, the call parameters are also logged.

  3. Detailed 1 includes the previous level information and adds information about the MOVE commands from/to File field buffers and the calls to the Get_Attribute and Set_Attribute commands.

  4. Detailed 2 includes the previous level information and adds text file generation through the driver.

  5. Detailed 3 includes all the information from the previous level, this option contains the most comprehensive level of trace information. It logs all calls to the driver and when they start and when they finish.

• See Also: Driver Trace Report

The user can look at the trace file, correct the data in the DataFlex file, and then run the migration process on the file again. The most common problems are in data fields.