Data Transformation Engine Database Interface Designer Reference Guide

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

Database Interface Designer Reference Guide

Criteria For Analyzing Differences

The criteria for analyzing differences for the different entities is as follows:

♦ .mdq file

! Any of the database definitions are different.

! Any of the variables are different.

! Any of the objects exist in one, but not the other, .mdq file.

♦ database definition

! Any of the database definition settings are different.

! Any of the syntax of the queries, column overrides of the stored

procedures, column overrides or update keys of the tables, or any of the

values of the variables are different.

♦ query

! The syntax of the queries is different.

! Column overrides of the queries are different.

♦ stored procedure

! Column overrides for the stored procedures are different.

♦ table

! Column overrides for the tables are different.

! Update keys for the tables are different.

♦ variable

! Values for the variables are different.

Creating a Database/query File Comparison

Use this procedure to compare database/query file differences between two

selected .mdq files. After you have created the comparison, you can view the

results.

To create an .mdq file comparison

1 From the File menu, select Database Query File Differences.

The Select First File dialog box appears.

2 Navigate your file system and select the first .mdq file to be compared.