• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 162
  • 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?
0
lrbrister
Asked:
lrbrister
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)
0
 
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?
0
 
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?>
No
---
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
https://technet.microsoft.com/en-us/library/ms345099(v=sql.105).aspx
0
 
lrbristerAuthor Commented:
Thanks
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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