SELECT 'DBFirst' AS DbName,
C1.TABLE_NAME,
C1.COLUMN_NAME,
C1.DATA_TYPE,
' <=>' AS DIFFERENCE,
'DBSecond' AS DbName,
C2.TABLE_NAME,
C2.DATA_TYPE,
C2.COLUMN_NAME
FROM DBFirst.[INFORMATION_SCHEMA].[COLUMNS] C1
INNER JOIN DBSecond.[INFORMATION_SCHEMA].[COLUMNS] C2
ON C1.COLUMN_NAME = C2.COLUMN_NAME
WHERE 1 = 1
AND C1.TABLE_NAME = C2.TABLE_NAME
AND C1.DATA_TYPE <> C2.DATA_TYPE
C1.TABLE_NAME,
C1.COLUMN_NAME,
C1.DATA_TYPE,
' <=>' AS DIFFERENCE,
'DBSecond' AS DbName,
C2.TABLE_NAME,
C2.DATA_TYPE,
C2.COLUMN_NAME
FROM DBFirst.[INFORMATION_SCHEMA].[COLUMNS] C1
INNER JOIN DBSecond.[INFORMATION_SCHEMA].[COLUMNS] C2
ON C1.COLUMN_NAME = C2.COLUMN_NAME
WHERE 1 = 1
AND C1.TABLE_NAME = C2.TABLE_NAME
AND C1.DATA_TYPE <> C2.DATA_TYPE
No comments:
Post a Comment