How do I find out the differences in data between the two tables that have exact schema, and how to produce synchronisation SQL to get the union results (without duplicates) ?
These are the 2 tables:
SOURCE01.dbo.Customers (31,022 rows)
TARGET01.dbo.Customers (29,300 rows)
The schema of each table is :
[CustomerId] : nvarchar(255)
[CreatedDatetime] : DateTime