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.