|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
Developing CLR Objects - Visual Studio Requirements?I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation,
and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere on either system's VS installation the option to create a new Sql Project/Solution to create CLR objects. Am I missing something, or do I need VS Professional? Craig Hi Craig,
the option should be under FIle --> New --> Project --> (Programming Language, e.g. C# ) --> Database --> SQLServer project In the Project you can define new object types like functions / procedures / UDA etc. HTH, Jens Suessmeyer. AFAIK, you need VS Professional version or (beta of) Team System dev.
Cheers, Bob Beauchemin http://www.SQLskills.com/bobb Show quote "Craig S" <cscheets@dontspam.kc.rr.com> wrote in message news:e$AATwKDGHA.1384@TK2MSFTNGP11.phx.gbl... >I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation, >and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere >on either system's VS installation the option to create a new Sql >Project/Solution to create CLR objects. Am I missing something, or do I >need VS Professional? > > Craig > You don't need to use Visual Studio to create and run
assemblies in SQL Server: http://www.eggheadcafe.com/articles/sql_server_2005_clr_regex.asp Show quote "Craig S" <cscheets@dontspam.kc.rr.com> wrote in message news:e$AATwKDGHA.1384@TK2MSFTNGP11.phx.gbl... >I have SQL 2005 Express & Visual Studio 2005 Standard on my XP workstation, >and SQL 2005 Standard installed on my Win2k3 server. I can't find anywhere >on either system's VS installation the option to create a new Sql >Project/Solution to create CLR objects. Am I missing something, or do I >need VS Professional? > > Craig > True. By the description in the posting, it appeared that he was looking for
the built-in Visual Studio "SQL Server Projects" for .NET languages, that are included as part of some editions of Visual Studio. You could conceivably develop and deploy SQLCLR assemblies with a command line compiler and SQLCMD.exe. Cheers, Bob Beauchemin http://www.SQLskills.com/blogs/bobb Show quote "Robbe Morris [C# MVP]" <i***@eggheadcafe.com> wrote in message news:%23XoVWSLDGHA.3984@TK2MSFTNGP14.phx.gbl... > You don't need to use Visual Studio to create and run > assemblies in SQL Server: > > http://www.eggheadcafe.com/articles/sql_server_2005_clr_regex.asp > > -- > Robbe Morris - 2004/2005 Microsoft MVP C# > http://www.eggheadcafe.com/forums/merit.asp > > > > > > "Craig S" <cscheets@dontspam.kc.rr.com> wrote in message > news:e$AATwKDGHA.1384@TK2MSFTNGP11.phx.gbl... >>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP >>workstation, and SQL 2005 Standard installed on my Win2k3 server. I can't >>find anywhere on either system's VS installation the option to create a >>new Sql Project/Solution to create CLR objects. Am I missing something, >>or do I need VS Professional? >> >> Craig >> > > Niels Berglund has released an custom SQL Server project, VS addin and a
stand-alone SQL CLR deployment tool which work with any edition of Visual Studio. http://staff.develop.com/nielsb/code/DeployPropAndAddIn.zip David Show quote "Bob Beauchemin" <no_bobb_spam@sqlskills.com> wrote in message news:%23AIOLzMDGHA.628@TK2MSFTNGP14.phx.gbl... > True. By the description in the posting, it appeared that he was looking > for the built-in Visual Studio "SQL Server Projects" for .NET languages, > that are included as part of some editions of Visual Studio. > > You could conceivably develop and deploy SQLCLR assemblies with a command > line compiler and SQLCMD.exe. > > Cheers, > Bob Beauchemin > http://www.SQLskills.com/blogs/bobb > > > "Robbe Morris [C# MVP]" <i***@eggheadcafe.com> wrote in message > news:%23XoVWSLDGHA.3984@TK2MSFTNGP14.phx.gbl... >> You don't need to use Visual Studio to create and run >> assemblies in SQL Server: >> >> http://www.eggheadcafe.com/articles/sql_server_2005_clr_regex.asp >> >> -- >> Robbe Morris - 2004/2005 Microsoft MVP C# >> http://www.eggheadcafe.com/forums/merit.asp >> >> >> >> >> >> "Craig S" <cscheets@dontspam.kc.rr.com> wrote in message >> news:e$AATwKDGHA.1384@TK2MSFTNGP11.phx.gbl... >>>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP >>>workstation, and SQL 2005 Standard installed on my Win2k3 server. I >>>can't find anywhere on either system's VS installation the option to >>>create a new Sql Project/Solution to create CLR objects. Am I missing >>>something, or do I need VS Professional? >>> >>> Craig >>> >> >> > > Yep. I was aware of that too. ;-) It sounded as though the questioner was
asking/wondering why the built-in projects didn't show up, rather than what are the choices when... Bob Beauchemin http://www.SQLskills.com/blogs/bobb Show quote "David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in message news:eYUIWFNDGHA.748@TK2MSFTNGP12.phx.gbl... > Niels Berglund has released an custom SQL Server project, VS addin and a > stand-alone SQL CLR deployment tool which work with any edition of Visual > Studio. > > http://staff.develop.com/nielsb/code/DeployPropAndAddIn.zip > > David > > > "Bob Beauchemin" <no_bobb_spam@sqlskills.com> wrote in message > news:%23AIOLzMDGHA.628@TK2MSFTNGP14.phx.gbl... >> True. By the description in the posting, it appeared that he was looking >> for the built-in Visual Studio "SQL Server Projects" for .NET languages, >> that are included as part of some editions of Visual Studio. >> >> You could conceivably develop and deploy SQLCLR assemblies with a command >> line compiler and SQLCMD.exe. >> >> Cheers, >> Bob Beauchemin >> http://www.SQLskills.com/blogs/bobb >> >> >> "Robbe Morris [C# MVP]" <i***@eggheadcafe.com> wrote in message >> news:%23XoVWSLDGHA.3984@TK2MSFTNGP14.phx.gbl... >>> You don't need to use Visual Studio to create and run >>> assemblies in SQL Server: >>> >>> http://www.eggheadcafe.com/articles/sql_server_2005_clr_regex.asp >>> >>> -- >>> Robbe Morris - 2004/2005 Microsoft MVP C# >>> http://www.eggheadcafe.com/forums/merit.asp >>> >>> >>> >>> >>> >>> "Craig S" <cscheets@dontspam.kc.rr.com> wrote in message >>> news:e$AATwKDGHA.1384@TK2MSFTNGP11.phx.gbl... >>>>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP >>>>workstation, and SQL 2005 Standard installed on my Win2k3 server. I >>>>can't find anywhere on either system's VS installation the option to >>>>create a new Sql Project/Solution to create CLR objects. Am I missing >>>>something, or do I need VS Professional? >>>> >>>> Craig >>>> >>> >>> >> >> > > I was kind of asking both, mainly "how do I develop one without notepad.exe"
:) I found all of these posts to be both correct and very helpful, thank Craigyou all. Show quote "Bob Beauchemin" <no_bobb_spam@sqlskills.com> wrote in message news:uCuImBODGHA.1124@TK2MSFTNGP10.phx.gbl... > Yep. I was aware of that too. ;-) It sounded as though the questioner was > asking/wondering why the built-in projects didn't show up, rather than > what are the choices when... > > Bob Beauchemin > http://www.SQLskills.com/blogs/bobb > > > "David Browne" <davidbaxterbrowne no potted m***@hotmail.com> wrote in > message news:eYUIWFNDGHA.748@TK2MSFTNGP12.phx.gbl... >> Niels Berglund has released an custom SQL Server project, VS addin and a >> stand-alone SQL CLR deployment tool which work with any edition of Visual >> Studio. >> >> http://staff.develop.com/nielsb/code/DeployPropAndAddIn.zip >> >> David >> >> >> "Bob Beauchemin" <no_bobb_spam@sqlskills.com> wrote in message >> news:%23AIOLzMDGHA.628@TK2MSFTNGP14.phx.gbl... >>> True. By the description in the posting, it appeared that he was looking >>> for the built-in Visual Studio "SQL Server Projects" for .NET languages, >>> that are included as part of some editions of Visual Studio. >>> >>> You could conceivably develop and deploy SQLCLR assemblies with a >>> command line compiler and SQLCMD.exe. >>> >>> Cheers, >>> Bob Beauchemin >>> http://www.SQLskills.com/blogs/bobb >>> >>> >>> "Robbe Morris [C# MVP]" <i***@eggheadcafe.com> wrote in message >>> news:%23XoVWSLDGHA.3984@TK2MSFTNGP14.phx.gbl... >>>> You don't need to use Visual Studio to create and run >>>> assemblies in SQL Server: >>>> >>>> http://www.eggheadcafe.com/articles/sql_server_2005_clr_regex.asp >>>> >>>> -- >>>> Robbe Morris - 2004/2005 Microsoft MVP C# >>>> http://www.eggheadcafe.com/forums/merit.asp >>>> >>>> >>>> >>>> >>>> >>>> "Craig S" <cscheets@dontspam.kc.rr.com> wrote in message >>>> news:e$AATwKDGHA.1384@TK2MSFTNGP11.phx.gbl... >>>>>I have SQL 2005 Express & Visual Studio 2005 Standard on my XP >>>>>workstation, and SQL 2005 Standard installed on my Win2k3 server. I >>>>>can't find anywhere on either system's VS installation the option to >>>>>create a new Sql Project/Solution to create CLR objects. Am I missing >>>>>something, or do I need VS Professional? >>>>> >>>>> Craig >>>>> >>>> >>>> >>> >>> >> >> > >  |
|||||||||||||||||||||||
Other interesting topics