Deplying CLR Stored procedure

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Development » Deplying CLR Stored procedure

Deplying CLR Stored procedure

Rate Topic

Display Mode

Topic Options

Author

Message

SQL*

Posted Friday, October 15, 2010 4:23 AM

SSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 5:09 AM
Points: 415, Visits: 1,458

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

thanks,

Smile

Post #1005023

g.silampathy

Posted Monday, October 15, 2012 5:46 AM

Grasshopper

Group: General Forum Members
Last Login: Tuesday, May 07, 2013 5:54 AM
Points: 19, Visits: 47

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;

Post #1372666

Lowell

Posted Monday, October 15, 2012 6:09 AM

SSChampion

Group: General Forum Members
Last Login: Yesterday @ 6:41 PM
Points: 11,648, Visits: 27,760

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

--There is no spoon, and there's no default ORDER BY in sql server either.
Actually, Common Sense is so rare, it should be considered a Superpower. --my son

Post #1372675

« Prev Topic | Next Topic »

Permissions