May 14, 2010 at 2:28 pm
When I move a databse containing CLR Assemblies & stored procedures from one server to another, do I need the dll file to reload the assembly? I know I have to set the Trustworthy option appropriately. I couldn't find anything related to this quickly on google and need to ensure it all works after its moved.
Thanks in advance!!!
May 14, 2010 at 3:09 pm
afaik you nolonger need the assembly once you have created it in sqlserver.
You can even script it. That will generate a long binary string, but will be portable.
So you can just restore the db at a new location and keep on using the clr function (as long as the clr environment has been activated is sys.configurations)
(this off course only as long as your clr assembly actually contains all code it needs!)
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply