I created SQl which shows the different data counts between two different databases ( selected tables) but I want to see data instead of counts.
These two databases are running on two different servers.
Below is query
Say you have two tables and your hypothesis is that they are identical in every respect, and you want to test that hypothesis. There are three things to consider.
To test all this is simpler than you might think. Remember you're working with sets.
If these exercises produce zero rows, and no errors you have identical tables. Assuming you have identical columns, your output will be all the rows that don't match in some way.
answered Mar 01, 2016 at 12:28 PM
The basic technique for returning non-matching lines is quite simple:
This returns a data set:
This gives the items in
As for doing it with your data... I'm leaving that to you. Sorry.
answered Mar 01, 2016 at 09:04 AM