Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2008 Forums  Other SQL Server 2008 Topics  Scripting out a CLR Assembly from Command Line

Author  Topic  Tevya Starting Member 3 Posts Posted - 2010-02-08 : 19:43:51 I am looking for a command line mechanism (no SSMS GUI) to take a named assembly that has been loaded into a named database in the SQL Server instance and generate a .sql file by scripting out that assembly. The only way have been able to see doing this so far has been via the SSMS gui (you know: right click on the assembly and select "Script Assembly As" etc. ). This is impractical for me if I want to store the script in some sort of source control and keep that script up-to-date with the compiled-and-deployed assembly. I have scanned the various tools and found nothing to cover this particular issue. Any direction out there? Thanks. Tevya