How to delete stored procedures from a database project and have that reflect on the server?
4
votes
2
answers
3965
views
I have a Visual Studio database project with several stored procedures. I deleted one of them and then published the project. But the SP was still present on the published database and I had to delete manually.
I would want the VS project to be the point of truth for the database. But at the same time, I'm publishing to a production database that has data.
Is there a way to delete files in a VS database project so that those changes reflect on the published database?
Asked by Zach Smith
(2430 rep)
Aug 31, 2017, 12:17 PM
Last activity: Jun 28, 2018, 10:50 AM
Last activity: Jun 28, 2018, 10:50 AM