Viewing database/query file differences

Edit online

About this task

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:

Procedure

  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.

    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.