title: visual studio 2012 SQL CLR
body: <p>I am trying to create, test and deploy a SQL CLR (database project) using Visual Studio 2012 (update 2) and it is getting very frustrating.</p>
  
  <p>The coding itself was trivial but now I cannot deploy or execute unit tests on the project.  I have developed SQL CLR in VS 2010 and it was much simpler (Test.sql).</p>
  
  <p>So here are my questions:</p>
  
  <ol>
  <li><strong>How does one set up a local SQL script to test the newly minted functions/sprocs?</strong> [I have tried adding a .sql file and marking it to be run on debug but I get error SQL71006.]</li>
  <li><strong>How does one deploy the project?</strong>  I am deploying to SQL 2008 R2 and I know I need to use .NET 2.0 but I still have not been able to deploy anything. When I execute the generated .SQL on the target SQL Server instance, nothing happens (no errors, nothing).</li>
  </ol>
  
  <p>This has worked so well with previous versions of Visual Studio one wonders if MSFT is perhaps now trying to discourage the generation of SQL CLR modules?</p>