title: Getting Sql Server Data Tools to work with Visual Studio 2012 Express Release Candidate
body: <p>I'm struggling with migrating to Visual Studio 2012 Express Edition to handle a project that includes a database project with a .dbproj extension.  This blog <a href="http://visualstudiomagazine.com/blogs/data-driver/2012/06/getting-visual-studio-2012-and-ssdt-to-work-together.aspx" rel="noreferrer">http://visualstudiomagazine.com/blogs/data-driver/2012/06/getting-visual-studio-2012-and-ssdt-to-work-together.aspx</a> gives the impression that with a bit of work this is all basically manageable. </p>
  
  <p>First you have to convert the .dbproj to a .sqlproj in Visual Studio 2010.  </p>
  
  <p>I managed to install Visual Studio 2010. This allowed me to convert the .dbproj to a .sqlproj.  From there the idea is to install Sql Server Data Tools (<a href="http://msdn.microsoft.com/en-us/data/tools.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/data/tools.aspx</a>) and open the sqlproj project in Visual Studio 2012, but I was unable to open the sqlproj in Visual Studio 2012.</p>
  
  <p>I've tried the suggested repair from here <a href="http://blogs.msdn.com/b/ssdt/archive/2012/06/07/upgrade-issue-to-visual-studio-2012-rc.aspx" rel="noreferrer">http://blogs.msdn.com/b/ssdt/archive/2012/06/07/upgrade-issue-to-visual-studio-2012-rc.aspx</a> and also the advice about repairing here <a href="http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/c66c2296-c94e-4f21-993e-7d3090a596a5" rel="noreferrer">http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/c66c2296-c94e-4f21-993e-7d3090a596a5</a>, but no matter what I do I can't create or open a sqlproj type project in Visual Studio Express 2012 RC for Web. Does anyone know how to resolve this?</p>
  
  <p>UPDATE:
  This FAQ <a href="http://msdn.microsoft.com/en-us/subscriptions/hh322942.aspx" rel="noreferrer">http://msdn.microsoft.com/en-us/subscriptions/hh322942.aspx</a> makes it clear that you have to work with an SQL Server Database Project in Visual Studio 2010 Shell not in Visual Studio 2010 or 2012 for Web.  </p>
  
  <p>My problem now is that I can create a completely new project by importing SQL scripts manually and going from there, but when I open up the .sqlproj file and try to work with that SQL Server Project I get a lot of spurious errors from Stored Procedures which are in fact perfectly valid.</p>