Visual Studio 2010 SQL Server Database Project - Ignore Stored Procedures and Functions
Posted
by Carter
on Stack Overflow
See other posts from Stack Overflow
or by Carter
Published on 2010-05-25T20:31:11Z
Indexed on
2010/05/25
22:51 UTC
Read the original article
Hit count: 319
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.
© Stack Overflow or respective owner