Search ...

781.329.4300 ¦ Message us ¦ Customer support login ¦ Product documentation

Services
Custom reporting
Data integration
DBA services
EHR conversion
Expanse migration
Staff augmentation
Quality
Quality Services
Chart Abstracted Measures
Mapping Services
Quality Resources
Solutions
Downtime Defender
Empower
OneLink
Power BI
ViewPoint
The Hub
Advisor
DR Network
Events
News
Education
Live online classes
Power BI training
Training videos
MUSE Conference
About
About us
Careers
How we work
Our team
KIND Award
Contact

You are here:
Home
DR Network
TSQL code
Compare DR Schemas

Welcome to the DR Network.

Everything you need to get started building reports with Data Repository. All free and available for every MEDITECH version from MAGIC to Expanse. Sign up today!

Your name*

Your email address*

MEDITECH version

MAGIC

C/S

6.0x

Expanse

Your organization

I'm interested in learning more about (select all that apply)*

Empower or Power BIDowntime DefenderQuality servicesCustom reports

DR supportData integrationOther

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