When doing a schema compare from a Visual Studio project to a database hosted in SQL Server the following error message appeared:
This error message appeared because I was using SQL Server 2012 in this specific development environment and hadn’t updated the SQL Server Data Tools (SSDT) to the correct version to support SQL Server 2012.
Solution: Upgrade SSDT for Visual Studio to the latest version and update the database project.
Update the Data-Tier Application Framework
Update the Project
Visual Studio 2010 (and 2012) Premium and Ultimate support comparison and synchronization of database schemas. this feature is described on MSDN here:
…provides an integrated environment for database developers to carry out all their database design work for any SQL Server platform (both on and off premise) within Visual Studio. Database developers can use the SQL Server Object Explorer in VS to easily create or edit database objects and data, or execute queries…
News about the upcoming release of Visual Studio starts to pop up everywhere. Here is a video demonstrating some of the features involving SharePoint development. It seems to address some of the shortcomings of the current approach.