Skip to content
  • There are no suggestions because the search field is empty.

T SQL Script: Check for schema differences between two databases

T SQL Script: Check for schema differences between two databases

--Check for schema differences between two databases
SELECT 
    a.TABLE_NAME,
    a.COLUMN_NAME,
    a.DATA_TYPE AS DataType_DB1,
    b.DATA_TYPE AS DataType_DB2
FROM BACASNG12.INFORMATION_SCHEMA.COLUMNS a
FULL OUTER JOIN BACASNG12_0.INFORMATION_SCHEMA.COLUMNS b
    ON a.TABLE_NAME = b.TABLE_NAME
   AND a.COLUMN_NAME = b.COLUMN_NAME
WHERE a.DATA_TYPE <> b.DATA_TYPE
   OR a.DATA_TYPE IS NULL
   OR b.DATA_TYPE IS NULL;