Is there a possibility to auto-generate a SQL Script for cataloging assembly?

Is there a possibility to auto-generate a SQL Script for cataloging assembly?

• madzip

  Out-of-the-box there is no way in Visual Studio .NET 2005 to auto-generate a SQL-Script for cataloging a .NET assembly into the SQL Server 2005 CLR. I mean following:
  
  This is my Class (Arith.dll):
  
  public class Math
  {   
   public static int invert() 
      { ... }
   public static int not()  
   { ... }
  }
  
  I want VS to generate the following:
  
  CREATE ASSEMBLY Arith ...
  go
  CREATE FUNCTION invert ...
  CREATE FUNCTION not ...
  
  Do you now a way to do this
  Regards, Alex

  
  

• david_dev

  NNTP User wrote:

  For other (cheaper) editions, you might want to check out Niels Berglund's custom deployment task:   http://www.sqljunkies.com/WebLog/nielsb/archive/2005/05/03/13379.aspx

  
  
  Hi Adam,
  
  thanks a lot, I think (I havent tested it yet) that's the thing I searched... ;-)
  
  Regards, Alex
  
• Is there a possibility to auto-generate a SQL Script for cataloging assembly?