How to Compare different tables in same Database
Carsten_Davidsen
Posts: 2 New member
I have a DB with two tables where the one is a backup of the other one.
How can I compare the two tables using SQL Data compare.
How can I compare the two tables using SQL Data compare.
Tagged:
Best Answer
-
BrainDonor Posts: 57 Silver 2Data Compare does it's best to map tables from the Source to the Target. So, it is a two-stage process to override this - you need to unmap what it has mapped and tell it to map the tables as you want it to.
In my example below I'm using a copy of an old ASP_State database and I have copied ASPTempSessions to ASPTempSessions_Copy. Currently, Data Compare has mapped the tables as you would expect.
First, I select ASPTempSessions and click on the 'unmap' button.
Then I select ASPStateTempSessions_Copy and do the same. This gives me a screen that shows tables that are no longer mappedy, in the lower half of the dialog.
Now, I can select the two tables that I want to compare against each other.
And then press 'Map'. This will then the two tables mapped to each other, so you can select them for camparison.
Answers
I've used it this way for checking how data has changed, after a test run of an update.
I selected my DB as Source and Target
Clicked on tap Tables and Views.
How can I select the two tables I marked in the picture ?