Visual Studio: How to Compare Database Schemas

How to Compare Database Schemas in Visual Studio 2013 Ultimate. You can use Visual Studio Premium or Visual Studio Ultimate to compare a target schema with a source schema

For each difference, you can specify whether to update the target so that it matches the source. You can write those updates directly to the target, or you can export the update script to the Transact-SQL editor or to a file. You can also save your comparisons, either as part of your database project or as a stand-alone file.