Compare tables on the same database

Hi,

How can I compare the tables on the same database ?
Eg: I have dbo.AccountSummary and dbo.AccountSummary_Replica. I want to compare these two tables and update replica with the new or update data. I know I can achieve this with SSIS but just wondered if this can be achieved using SQL data compare. 

Answers

Sign In or Register to comment.