Deplying CLR Stored procedure

Question

Deplying CLR Stored procedure

SQL*

SSCertifiable

Points: 6638
More actions
October 15, 2010 at 4:23 am

#97508

HI,
How can i deploy the CLR Stored procedure to production i.e., different server.
thanks,
🙂

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

g.silampathy Valued Member Points: 62 More actions · Answer 1

create your assembly in your production database using the below statement.Build your project and copy your .dll to your prod server .

CREATE ASSEMBLY sqlcrlProcName from 'C:\CLRProcFiles\SQLProc.dll' with PERMISSION_SET = SAFE

to enable CLR feature in your database :

use master

GO

EXEC sp_configure 'show advanced options' , '1';

reconfigure;

EXEC sp_configure 'clr enabled' , '1' ;

reconfigure;

EXEC sp_configure 'show advanced options' , '0';

reconfigure;

Lowell SSC Guru Points: 323518 More actions · Answer 2

additinally, since you've deployed it on one server already, you can actually script them out as a binary blob and install them via a script...the script may load slow as hell when you open it in SSMS, because teh binary string is thousands of characters long, but it works:

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!