Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Comparing Database/query Files
Database Interface Designer Reference Guide
42
Database/query File Difference Results
When database/query source files are compared, they are considered different if
any of the database definition settings are different, any of the variables are
different, or any of the objects exist in one .mdq file and not the other. Text color
is used to provide a visual distinction. Refer to the table below as a guide:
Condition Upper Panes Lower Panes
Same name and
content
black text black text on tab, only one pane at a time
Same name,
different content
red text red text on tab, both panes appear, unique
text in red
Different name and
content
blue text red text on tab, only one pane at a time,
unique text in green (for database settings
only, rest have unique text in blue)
For more information about how to view these differences, refer to the links
below:
♦ Database Definition Setting Differences
♦ Query Differences
♦ Variable Differences
♦ Unique Database Information
♦ Stored Procedure Differences
♦ Table Differences
Database Definition Setting Differences
If any database definition settings of either of the two compared .mdq files are
different, both database names appear in red letters in the Database
Differences window.
The Database Properties tab in each lower windowpane also appears in red
letters. (If there were no differences, this tab would appear in black letters.)