SQL Server 2012 SP 1 Breaks SQL Server Database Projects
November 16, 2012 6 Comments
After installing SQL Server 2012 Service Pack 1 you will discover that SQL Server Database Projects can no longer be opened (or created) using SQL Server Data Tools (SSDT). The error presented when trying to open existing projects is:
Unable to open Database Project
This version of SQL Server Data Tools is not compatible with the database runtime components installed on this computer
(BTW, Clicking on the “Learn more…” and “Get the latest version of SQL Server Data Tools…” links at the bottom of the dialog returns “Page not Found” errors.)
To fix this problem you need to install SQL Server Data Tools – November 2012 update. That said, when you now try and open an existing project/solution, you are advised that the project needs Migrating however no migration wizard is launched and there is no visible way of migrating the project.
To migrate your project you need to Right Click on the Project name and select “Reload Project”.
This will launch the “One-way Upgrade wizard” which converts your project into the latest version of SSDT.
Would be nice if SP 1 included the SSDT update and that the migration wizard automatically launched when opening a project.