Compare tables on the same database
surpreeti
Posts: 2 Bronze 1
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.
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