Data Transformation Engine Database Interface Designer Reference Guide

Chapter 3 - Database/query Files Editing or Deleting a Database or Query
Database Interface Designer Reference Guide
39
Editing or Deleting a Database or Query
To edit a database or query
1 In the Navigator, select the name of the database or query to be edited.
2 From the Database menu (or Query menu as appropriate), select Edit.
or
In the Navigator, right-click the database or query icon and select Edit.
The Edit/View Query dialog box appears.
3 Make any necessary changes and click OK.
To delete a database or query
1 In the Navigator, highlight the database(s) or one or more queries you want
to delete.
2 From the Database menu (or Query menu as appropriate), select Delete.
or
In the Navigator, right-click the database or query icon(s) and select Delete.
A confirmation dialog box appears.
3 To confirm the deletion, click Yes.
Comparing Database/query Files
Database/query (.mdq) files contain definitions of one or more databases, as well
as queries, stored procedures, tables, queues, and variables. The file
differentiation process identifies .mdq file differences first at the database-level,
and then at the query-, stored procedure-, table-, and variable-levels. For
information, refer to Creating a Database/query File Comparison.
After you have performed a comparison between two .mdq files, color-coding is
used to highlight what is unique between the two:
♦ Differences are highlighted in red.
♦ New information is highlighted in blue.
For more information, refer to Viewing Database/query File Differences.