44

After installing the release version of VS2012, I am unable to find SQL CLR proect template. How can I go about creating a project of this type.

Thanks!

laconicdev
  • 6,085
  • 11
  • 59
  • 88

1 Answers1

72

All of the various database objects are now created inside of SQL Server database projects.

They've removed the distinction between database projects (SQL Scripts) and SQL CLR projects.

So it's just File -> New -> Project, Installed -> Templates -> SQL Server, SQL Server Database Project.

Then, if you go to Add -> New Item, you'll find various categories on the left, including (confusingly) SQL CLR and SQL CLR C#. The first is for generating SQL Scripts for adding CLR objects, the second is for creating the actual CLR objects themselves.

Damien_The_Unbeliever
  • 220,246
  • 21
  • 302
  • 402
  • "So it's just File -> New -> Project, Installed -> **Templates** -> **SQL Server**, SQL Server Database Project." Only problem is that I don`t have SQL server under templates. How do I resolve this? – Joakim Sep 05 '12 at 05:29
  • 3
    @Joakim: you must install Microsoft SQL Server Data Tools if you don't have the templates (http://msdn.microsoft.com/en-us/data/tools.aspx) – Alex B Dec 19 '12 at 15:20
  • 8
    For me: File -> New Project -> Installed -> Templates -> **Other Languages** -> SQL Server – Ryan R. Jan 09 '13 at 02:21
  • I seem to have the 'sql clr' and 'sql clr vb' templates available in ssdt 2010 and ssdt 2012. I'm open to suggestions on how to get 'sql clr c#' added. Causes or solutions? – JSacksteder Jan 24 '15 at 18:53
  • 1
    Upped for being applicable to VS 2013. – craig Feb 05 '15 at 17:56