phone icon 781.329.4300  ¦  Message us  ¦ Customer support login ¦ Product documentation

  1. You are here:  
  2. Home
  3. DR Network
  4. TSQL code
  5. Compare DR Schemas

Welcome to the DR Network.

The DR Network has everything you need to get started building reports with Data Repository, including T-SQL stored procedures and functions, SSRS report definition files, and even Report Designer reports. Everything is free to the MT community and available for every MT version from MAGIC to Expanse. Sign up today!
Contact us
500 characters left

Compare DR Schemas

TSQL code
  • MT platform: All

This TSQL query is useful to compare DR database schemas between test and live databases. This script produces a detailed list of changes by comparing your existing release in live against a newer version in test, and shows changed items by category (new tables, new columns, removed columns, datatype changes, etc.).

To download this report, please log in or create an account. → 

compare dr schemas