Mar 7, 2018 - Do a search for 'SQL Server Compare' and you'll find lots of tools. Text file compare tool (even MS Word) or you can dump the results to tables. Compalex is a free lightweight script to compare two database schemas.
Use Cases • Upgrade and downgrade databases between different versions and editions of SQL Server or Oracle Database. • Migrate between SQL Server, Azure SQL Database, and Amazon RDS for SQL Server.
• Move between different database environments (such as testing, development, production, and archive). • Detect and repair unwanted database changes by comparing to backups and snapshots. • Restore damaged databases down to individual objects instead of full database restores. • Compare problematic databases to normal databases to find root cause. • Verify successful database migration and replication. • Review progress in development by exploring differences in schemas and data.