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 SSDT
- 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:
Microsoft SQL Server Data Tools …
…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…
Download the latest SSDT and Power Tools:
Download the Microsoft® SQL Server® 2012 Data-Tier Application Framework (November 2012)
How to: Convert VS 2010 Database Projects to SSDT Database Projects and Re-target to a Different Platform