SQL Delta
The tool is lightweight and easy to use. It’s designed to compare two databases, so you can see what changes occurred between one point in time and another. The output is in a table format that is easy to read. The tool lets you filter out all but the changed objects, making it much easier to track down specific changes or differences.
When comparing databases that are more than 500 MB each, SQL Delta may not be your best option because the file size limitations on GitHub limit it to 500MB files per download. If this is an issue for you, then take a look at dbDeltaXtreme instead. like renaming objects or copying entire schemas. There is also a side-by-side mode that allows the comparison of rows in both tables at once.
Read More4 Simple Tools to Compare SQL Server Databases