SqlDataComparison_Gist4.sql

SELECT 'OURS <<<' AS [ ],
	[ours].[AddressTypeID],
	[ours].[AddressType],
	'THEIRS >>>' AS [ ],
	[theirs].[AddressTypeID],
	[theirs].[AddressType]
FROM dbo.AddressTypes [ours]
FULL OUTER JOIN RemoteServer.CustomerDatabase.dbo.AddressTypes [theirs]
ON [ours].[AddressTypeID] = [theirs].[AddressTypeID]
WHERE [ours].[AddressTypeID] IS NULL AND [theirs].[AddressTypeID] IS NOT NULL
	OR [ours].[AddressTypeID] IS NOT NULL AND [theirs].[AddressTypeID] IS NULL
	OR [ours].[AddressType] IS NULL AND [theirs].[AddressType] IS NOT NULL
	OR [ours].[AddressType] IS NOT NULL AND [theirs].[AddressType] IS NULL
	OR [ours].[AddressType] <> [theirs].[AddressType]