How can I script out my loaded SQLCLR assembly without having to go through the GUI? We like to keep the .SQL files in our source control and I would like to be able to regenerate the generated .sql for an assembly after each build/deploy of the assembly to the test database.
It would be nice to know how to use relative paths (and/or environment variables) with the "CREATE ASSEMBLY xxxx from" T-SQL command but if the the assembly creates stored procs or functions, then they have to be unloaded, the assembly unloaded and then both reloaded--yuck.
Much preferred to have a simple way of scripting out the assembly @ each build.
Thanks!
== Tevya ==