Search code examples
visual-studio-2010database-projectsql-server-2012sql-server-data-tools

How do I convert a Visual Studio 2010 database project to an SSDT Project


I have a clean install of windows 7 with Visual Studio 2010 Premium inc. SP 1. I also just installed the developer edition of SQL Server 2012 .

I now should be able to convert the Visual Studio 2010 database project to an SSDT project. According to this technet blogpost it should be as easy as opening my Visual Studio solution file and follow the conversion wizard. The problem is that the conversion wizard never appears. Also, the "Convert to SQL Server Database project..." context menu item does not exist when right clicking on the VS 2010 database project.

I'm probably missing something in my SQL 2012 installation. The question is: what?

My SQL 2012 install configuration: My SQL 2012 install configuration


Solution

  • Found the problem. Apparently I still needed to download SSDT standalone from http://www.microsoft.com/web/gallery/install.aspx?appid=SSDT. Althought SQL Server Data Tools is listed in the screenshot above.

    EDIT: Updated the link. Thanks @ryanwebjackson