Visual Studio 2010 SQL Server Database Project - Ignore Stored Procedures and Functions
- by Carter
I really like the new SQL Server Database projects in Visual Studio 2010. I also like using the "Generate DROP statements for objects that are in the target database but that are not in the database project" option in the deployment properties.
However, I do not want to manage Stored Procedures and Functions using this interface; I have another tool for that. Every time I do a build and deploy, VS will drop my stored procedures that I have created with my external program. I would like to essentially "ignore" stored procedures and functions.
Is there a way to ignore stored procedures and functions when building SQL Server Database projects?
I won't be able to use the "Generate DROP statements..." option if I want to use my external tool for stored procedures and functions.