CLR Development: Visual Studio Pro Version Required?
-
Subject says it all, really. Just beat my head against the wall for 2 hours, only to learn that the MS-provided "Visual Studio Premier Partner Edition" that comes with SQL Server 2005 Enterprise Edition doesn't actually allow you to create CLR?!
Is this true? I now have to purchase Visual Studio Pro. to build CLR? (Unless I follow persnickity procedures to build from scratch in a text editor and compile them.)
Is there another way around this, or am I stuck either not using CLR or buying VS Pro?
Thanks,
Rich Mechaber
-
that doesn't sound right...if you can do File>>New Project, is there a template for Database Project?
I know you can download the VS Database Template from MS, and there is instructions on where to put it if it is missing.
if you can do that, you can make CLR's. My Dev machine has vs already installed, I'll install BIDS on a virtual and report back.
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Lowell (6/14/2010)
that doesn't sound right...if you can do File>>New Project, is there a template for Database Project?I know you can download the VS Database Template from MS, and there is instructions on where to put it if it is missing.
if you can do that, you can make CLR's. My Dev machine has vs already installed, I'll install BIDS on a virtual and report back.
Thanks for responding.
No, there is no option in File, New Project for Database Projects. In fact, that's what got me looking. See attached screenshot, please, from Visual Studio.
Under Project Types, I have "Business Intelligence Projects" - which includes the installed templates (on the right-hand side) of Analysis Services, Integration Services, Report Model, Import Analysis Services 9.0, Report Server Project Wizard, and Report Server Project. Other than that, nothing except for "Visual Studio Solutions" and the Blank Solution.
This page suggests there are options (http://msdn.microsoft.com/en-us/library/bb129445%28VS.80%29.aspx), but in fact it also says the language-specific parts are not included. See this, for example: http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/4d6ebebd-af14-415c-b993-825f4d0a0863.
Finally, this page http://msdn.microsoft.com/en-us/library/b4z62wxz%28VS.80%29.aspx that lists the different versions shows that the "SQL Server Project" only comes with Pro version.
Am I missing something?
Thanks,
Rich
-
ok rich; I'm putting a link to CLR Database Project and it's solution; after unzipping it and opening it in the BIDS version of VS2008, if you go to the Build menu, does it look like this? it's the "Deploy" option that i found makes this really easy to do.
mine DOES have the Deploy option when i select 2008/BIDS, but i also have VS installed, and it may have tweaked it so it's no longer the vanilla BIDS anymore.
here's the project to download and open:
Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible! -
Sorry to say, but from what I am reading here, you won't be able to build CLR using this edition:
Features in the Visual Studio Premier Partner Edition
The Premier Partner Edition (PPE) provides a version of Visual Studio that includes the Visual Studio IDE, the debugger, and source code control integration. No programming languages are included. Although PPE does not include programming languages, PPE does provide a framework that lets you add programming languages.
You need Pro or better to get SQLCLR integration
----------------------------------------------------------------------------------
Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again? -
Lowell (6/14/2010)
ok rich; I'm putting a link to CLR Database Project and it's solution; after unzipping it and opening it in the BIDS version of VS2008, if you go to the Build menu, does it look like this? it's the "Deploy" option that i found makes this really easy to do.mine DOES have the Deploy option when i select 2008/BIDS, but i also have VS installed, and it may have tweaked it so it's no longer the vanilla BIDS anymore.
here's the project to download and open:
Thanks, Lowell: I really appreciate you taking the time to create this and upload it for me! 🙂
Unfortunately, I have SQL 2005 (see OP) and BIDS will not open your project (error message pops up), so I cannot test it. 🙁
I may just bite the bullet and purchase VS Pro, but I'm fairly irked that MS would create CLR for SQL 2005, push its use as a great new tool, make it extremely difficult to create CLR with the tools provided, and then not explicitly tell me that I need to purchase another product to make it work.
Whew, sorry for the rant....
Thanks again,
Rich
-
Why not use free Express edition of Visual Studio?
There is some example in C#
-
I ran into the same thing. Had a choice between buying Pro and using a text editor. Ended up programming in Notepad. It works, but I can't recommend it.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
Thanks GSquared for confirming this is an issue. (BTW, you must be a Larry Niven fan?)
I bit the bullet and downloaded VS Pro. We're an academic institution with a site license, so it turned out to be either free or very cheap. But most users won't have that luxury.
I haven't looked into using Express. I understand it works, but you need to install a third-party tool to allow deployment of the CLR you develop (http://social.msdn.microsoft.com/Forums/en/sqlnetfx/thread/192e7750-7b28-4ddd-9344-14df784a4fc0).
Yours,
Rich
-
rmechaber (2/28/2011)
Thanks GSquared for confirming this is an issue. (BTW, you must be a Larry Niven fan?)...I must be missing something. What did I write that indicates Larry Niven anywhere?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
-
Sorry, inference on my part: your moniker, GSquared, was used in a Larry Niven short story.
Rich
-
rmechaber (2/28/2011)
Sorry, inference on my part: your moniker, GSquared, was used in a Larry Niven short story.Rich
Ah. It's a nickname I picked up in high school, since my initials are GG.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
Viewing 12 posts - 1 through 11 (of 11 total)
You must be logged in to reply to this topic. Login to reply