如何使用数据库项目进行版本控制现有的存储过程?

时间:2022-09-11 17:05:02

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

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

Redgate SQL Source Cotrol

I believe they have a 28 day trial.

我相信他们有28天的试用期。