Visual Studio’s SQL Server Schema Compare works on SQL Azure databases, too

Both Visual Studio Ultimate and Visual Studio Premium support a very useful feature called SQL Server Schema Compare.

I've used this feature numerous times to compare two local (on-premises) SQL Server databases together, and correctly (and often automatically) updates either of these databases to match the newer schema with a click of a button.

Of course, Azure is here, so the question becomes: can I use Visual Studio to compare an on-premises, local SQL Server database to a database running on Azure? Yes, you can!

So, the next time you need to compare SQL Server databases, both local or cloud, let Visual Studio do the tedious work on your behalf.