• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 173
  • Last Modified:

SQL Server RDS clr assembly

Is it possible to store a clr assembly in a SQL Table.... and call it form there instead of a folder?
1 Solution
Nakul VachhrajaniTechnical Architect, Capgemini IndiaCommented:
You only need to create the assembly from a folder (i.e. physical dll) once. Once the assembly is created, you can simply right-click it in SSMS and choose to script out the assembly. It will produce a binary representation of the assembly which you can then embed into your deployment scripts.

This process is described here (https://msdn.microsoft.com/en-us/library/ms345099.aspx)
Máté FarkasDatabase Developer and AdministratorCommented:
Dear lrbrister,
Can you show me an example how you call a CLR assembly from a folder in SQL Server?
Eugene ZCommented:
<Is it possible to store a clr assembly in a SQL Table.... >
if you meant "DLL" -- yes

<and call it form there instead of a folder?>
Not sure why do you need this but

..as an idea...
with some "extra" steps

1st you can store file in sql server

2nd  you need to retrieve this file each time
and "deploy" and after  do "cleanup", etc

Deploying CLR Database Objects
lrbristerAuthor Commented:
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now