SQL Server 2012 SP 1 Breaks SQL Server Database Projects

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

ssdt

(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”.

image

This will launch the “One-way Upgrade wizard” which converts your project into the latest version of SSDT.

SNAGHTML52e6800

Would be nice if SP 1 included the SSDT update and that the migration wizard automatically launched when opening a project.

About these ads

About Mr. Wharty's Ramblings
Jeff holds a Master’s Degree in Systems Development (.NET Stream) and a Master’s Degree in Database Design and Management (SQL Server). Jeff is also a MCT specialising in SQL Server technologies and holds MCPD, MCITP, MCDBA and MCSD certifications.

5 Responses to SQL Server 2012 SP 1 Breaks SQL Server Database Projects

  1. Pingback: Unable to open Database Project after upgrading to SQL Server 2012 SP1 | gabrewer.com

  2. Michael B. Johnson says:

    Thank you, this was very helpful! Although SSDT appears to come with Visual Studio 2012, I had to download the latest version of SSDT from the Microsoft website in order to make this work.

  3. Rajanand says:

    I’m using SQL Server Data Tools 11.1.20627.00

    Visual Studio 2012

    SQL Server 2008 Management Studio 10.0.1600.22 ((SQL_PreRelease).080709-1414 )

    I have the same problem…

  4. Great post, very useful. Cheers!

  5. roshi mon says:

    Thank You. It worked :)

Leave a Reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 601 other followers

%d bloggers like this: