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:
Answer
In case it helps someone else.
In my case I did not get a wizard of any kind, even though I did ALL necessary installs.
Symptoms:
- Open solution in VS2012.
- Database project is unloaded, it says it needs migration.
- Reload database project, it says it requires functional changes (or something like it). I press OK.
- Database project is available, it builds, but when I close VS2012, and re-open the solution, it says the same thing over and over again.
Solution:
- Unknown to me VS2012 does create a new project of ssdt type. Unfortunately it doesn't load it. I have a project .dbproj file and a project .sqlproj file. The .dbproj file is loaded.
- Remove the database project from the solution.
- Add existing project -> select the .sqlproj file. The database project is loaded again. It builds.
Now everything seems well, I can open and build the solution in VS2012 without any problems. Also, I can reopen the solution in VS2010SP1, and it opens and builds without any problems.