Data Transformation Engine Database Interface Designer Reference Guide

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

Database Interface Designer Reference Guide

Stored Procedure Differences

If the stored procedures of the two compared .mdq files have the same name, but

different values, the stored procedure name will appear in red letters in the upper

pane and both stored procedures will appear in the bottom panes with the

Column Overrides tab letters also in red letters. In the bottom panes, the unique

value(s) will appear in red letters. If the stored procedure names of either of the

two compared .mdq files are different, the name of each stored procedure

appears in blue letters in the Database Differences window. If the stored

procedures are exactly the same, the name of the stored procedure in the upper

pane and the Column Overrides tab and columns would all appear in black

letters.

Note The columns on this tab (Column Name, Column Length, Presentation, and

Interpret As) correspond to fields and list names in the Column Datatype

Specification dialog box.

Table Differences

If the tables of the two compared .mdq files have the same name, but different

values for column overrides or update key definitions, the table name will appear

in red letters in the upper pane and both tables will appear in the bottom panes

with the Column Overrides and/or Update Keys tab letters also in red letters.

In the bottom panes, the unique value(s) will appear in red letters. If the table

names of either of the two compared .mdq files are different, the name of each

table appears in blue letters in the Database Differences window. If the tables

are exactly the same, the name of the table in the upper pane and the Column

Overrides and Update Keys tabs and related information would all appear in black

letters.

Click the Column Overrides and Update Keys tabs in each pane to view the

differences.

Note The columns on the Column Overrides tab (Column Name, Column Length,

Presentation, and Interpret As) correspond to fields and list names in the

Column Datatype Specification dialog box.