Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Comparing Database/query Files

Database Interface Designer Reference Guide

3 Click Open.

The Select Second File dialog box appears.

4 Navigate your file system and select the second .mdq source file to be

compared.

5 Click Open.

The progress of the comparison is shown briefly in the Database Source File

Differences Analysis dialog box. When the analysis has completed, the

Database Differences window appears.

Viewing Database/query File Differences

Note The Database Differences window should already appear. If you do not see it,

you must create the file comparison as described in Creating a Database/query

File Comparison.

Differences are indicated using color-coded text:

♦ Differences are red.

♦ Additions or new information items are blue.

To view .mdq file differences

1 Place current focus in the Database Differences window.

2 Resize any of the four panes as needed.

3 Select any database, query, stored procedure, table, or variable to view the

differences.

The settings display in the two lower windowpanes, depending upon what you

select.

4 Press F8 or F7 to view the next or previous difference, respectively.

Note In the Database Differences window, you can view all of the settings for the

selected element in the compared .mdq file, even though differences may not exist.