A simple SQL compare is realy easy: select * from dbtest02.dbo.article except select * from dbtest01.dbo.article Source: https://www.mssqltips.com/sqlservertip/2779/ways-to-compare-and-find-differences-for-sql-server-tables-and-data/