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 [...]