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. See 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.