tags:

views:

42

answers:

0
Q: 

Pre/Post deployment scripts in VS2010

We are migrating from VS2008 to Vs2010. Currently we have a VS 2008 SQL CLR project that uses predeployscript.sql and postdeployscript.sql files to run pre and post deploy scripts. Once the project was converted to VS2010 and I try to deploy it against a database, I get errors indicative of the fact that the predeploy script was not run. How can I get the pre-deploy script to run in VS2010. Thanks

related questions

SQL CLR SqlBulkCopy from DataTable
Is it ok to load .net dlls into SQL Server as UNSAFE?
Accessing TSQL created #temp tables from CLR stored procedure. Is it possible?
Deploy a CLR Trigger/Stored Procedure using WiX
Use optional arguments in SQLCLR
What are the limitations of a CLR context connection.
Problems with CLR Code on Sql Server 2005
SqlFunction fails to open context connection despite DataAccessKind.Read present
How do I update an assembly and its dependent assemblies in MS-SQL?
Error handling CLR routines
TSQL OLE (com) Objects
How to PRINT a message from SQL CLR function?
WCF Client Inside SQL CLR
Problem using OLEDB driver in SQL Server CLR procedure
Are CLR UDTs commonly used in enterprise applications?
Advantage of SQL SERVER CLR
Can SQL CLR triggers do this? Or is there a better way?
Sql Clr User Defined Type parsing a float and losing precision.
Get the names of attributes from an element in a SQL XML column
Why CLR integration assemblies have a random version number
CLR UDF Exception In SQL Server 2005
How do I profile a SQL CLR application?
Error Running CLR Stored Proc
Are CLR stored procedures preferred over TSQL stored procedures in SQL 2005+ ?
The difference between the connections strings in SQLCLR