如何仅更新存储过程 [英] How to update Stored Procedures Only

问题描述

我有一个部署到客户机的应用程序。我多次给他更新，现在我已经厌倦了逐个为他提供存储过程的更新。是否有任何方法可以创建所有存储过程的包并在
更新所有存储过程而无需麻烦。因此，无论新的变化如何，一切都会得到更新。如果不存在，也会创建新程序。

解决方案

是

您可以在SSDT中创建包含所有代码部分的数据库项目，然后使用dacpacs进行增量部署

参见

https：// www。 codeproject.com/Articles/1211951/SQL-Server-Database-Project-SSDT-Continuous-Delive

Hi,

I had a deployed an application to client machine. I gave him updates several times and now i am tired to provide him updates for stored procedures one by one. Is there any way using which i can create a package of all stored procedures and update all at once without hassle. So, everything will get updated regardless of new changes. Also new procedures will be created if not exist.

解决方案

yes

You can create a database project in SSDT including all code parts and then do incremental deployment using dacpacs

see

https://www.codeproject.com/Articles/1211951/SQL-Server-Database-Project-SSDT-Continuous-Delive

这篇关于如何仅更新存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！