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;
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;