What are the challenges you face when working across database platforms? Take the survey

Compare tables on the same database


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. 


Sign In or Register to comment.