Schema & data comparison utilites are commercially available off-the-shelf from various vendors (including Microsoft (as part of Visual Studio/SSDT) and RedGate).
Data Integrity Checking has a very wide scope - what do you mean by integrity? If it is just the consistency of the data on disk, DBCC would be a great starting point. If it is the relationship of data in your user tables, then it would have to be something custom built - I'm unaware of any off-the-shelf product that can help here.
Similarly, for logical analysis. What is the logical analysis that you are looking at? Do you want number of records in the table? The distribution of data across various files? Level of duplication of data, etc. Most of these questions require custom built solutions.
commented on Sep 30 2014 12:46PM