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

Question

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

Answer 1

Visual Studio Team Suite does that with its deployment task.

 

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

 

--
Adam Machanic
SQL Server MVP
http://www.datamanipulation.net
--

 

 

<Alexander [e-mail]> wrote in message news:[e-mail]...

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

Answer 2

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