The market offers a variety of good tools that can help to synchronize SQL Server environments, however there is a quick and dirty way that can be used to compare table schemas directly from Microsoft SQL Server which we will cover in this tip.
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.