I would like to version control the stored procedures same as an any application. After some research, I have found the following link:
我想版本控制存储过程与任何应用程序相同。经过一番研究,我发现了以下链接:
Version control stored procedures
版本控制存储过程
I have added a database project to my existing project and added a new stored procedure. And tried to copy the code from my existing stored procedure into the stored procedure and I see the following issue:
我已将数据库项目添加到现有项目中,并添加了一个新的存储过程。并尝试将我现有存储过程中的代码复制到存储过程中,我看到以下问题:
I am wondering if one of you can guide me if anything I am doing wrong or maybe tell me that I am barking up a wrong tree. There might be better ways of version controlling stored procedures.
我想知道你是否有人可以指导我,如果我做错了或者告诉我,我正在咆哮错误的树。可能有更好的版本控制存储过程的方法。
Thanks in advance.
提前致谢。
1 个解决方案
#1
2
I've used Redgate's SQL Source Control for a number of years now. You simply add your DB to the source control, allowing you then to take branches and merge back to the trunk at a later date. Hope this helps.
我已经使用了Redgate的SQL Source Control多年了。您只需将数据库添加到源控件,然后允许您在以后使用分支并合并回主干。希望这可以帮助。
Redgate SQL Source Cotrol
I believe they have a 28 day trial.
我相信他们有28天的试用期。
#1
2
I've used Redgate's SQL Source Control for a number of years now. You simply add your DB to the source control, allowing you then to take branches and merge back to the trunk at a later date. Hope this helps.
我已经使用了Redgate的SQL Source Control多年了。您只需将数据库添加到源控件,然后允许您在以后使用分支并合并回主干。希望这可以帮助。
Redgate SQL Source Cotrol
I believe they have a 28 day trial.
我相信他们有28天的试用期。