Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Deplying CLR Stored procedure Expand / Collapse
Author
Message
Posted Friday, October 15, 2010 4:23 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Wednesday, September 10, 2014 12:22 AM
Points: 415, Visits: 1,587
HI,
How can i deploy the CLR Stored procedure to production i.e., different server.

thanks,


Post #1005023
Posted Monday, October 15, 2012 5:46 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, August 26, 2014 10:27 AM
Points: 19, Visits: 48
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
Posted Monday, October 15, 2012 6:09 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 9:14 AM
Points: 12,918, Visits: 32,088
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 »

Add to briefcase

Permissions Expand / Collapse