Microsoft SQL Server: How to compare 2 databases
I recently had the problem that a software upgrade that also involved a database upgrade did not work correctly and the database was "half" upgraded.
So I wanted to find out what data has changed in this half upgraded database. If you search the Internet, you will find many people recommending some third-party database comparison tools that cost money. But I was looking to find a legal free alternative.
Actually, there is one from Microsoft itself:
Go and download:
SQL Server Data Tools
https://docs.microsoft.com/en-us/sql/ssdt/download-sql-server-data-tools-ssdt
I Read more [...]