How can I compare the records between 2 databases to compare that they are identical? SQL 2008

2

I have two Databases in Full Mode, taken from the same copy, but in one I debug the Log to leave it at 1 MB and in the other I leave it intact, as I can check that there has been no loss of information in which Was the Log debugged?

    
asked by Marraya27 08.03.2017 в 19:46
source

1 answer

0

One of the best tools for comparison between Databases and that I have been using for some time is the Red Gate tools, both SQL Data compare and SQL compare one for make comparisons of data and the other to make comparisons of structure, the only bad thing is that it is a paid tool but you can download the full version and use it for 30 days without restrictions, I leave you the link of the tools.

link

    
answered by 08.03.2017 в 20:53