关于如何发布/部署sql脚本的启示 [英] Inspiration on how to release/deploy sql script
问题描述
您好我公司正在运行Team foundation服务器的15.112.26301.0版。我正在寻找从一个环境到另一个环境部署/释放存储过程和其他sql脚本的最佳方法的一些灵感。我们在sql测试服务器上创建脚本（等等存储了
过程）。我们还将脚本放在TFS中，该解决方案包含一个包含所有sql脚本的文件夹。那么我们怎样才能将这个过程自动化到我们的其他环境？我看了一下DACPAC的任务。但它看起来像
我无法选择从某个数据库部署什么，它将部署所有表格。
Danske Bank的IT开发人员
Hi my company is running Version 15.112.26301.0 of Team foundation server. I am looking for some inspiration on the best way to deploy/release stored procedures and other sql script from one environment to another. We are creating our script (etc stored procedures) on our sql test server. We also place the script in TFS in a solution containing a folder with all our sql script. So how could we automate the process deploying this to our other enviroments?. I had a look on the DACPAC task. But it looks like I can´t choose what to deploy from a certain database it will deploy everything also tables.
IT Developer in Danske Bank
推荐答案
为了精确控制SQL Server对象版本控制，Redgate软件是此类工具的主要供应商。您也可以将自己的解决方案拼凑在一起，因此这是正常的构建/购买决策。我的建议是，编程工作室应该坚持其核心的
业务，而不是花时间开发那些对此没有贡献的解决方案。
For fine control of SQL Server object versioning, Redgate Software is the leading vendor for such tools. You can cobble your own solution together also, so it is a normal build/buy decision. My advice is that a programming shop should stick to its core business and not spend time developing solutions that do not contribute to that.
这篇关于关于如何发布/部署sql脚本的启示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
