blocks|key|871176|text|哦，这是你应该早点考虑的事情。一种方法是:将SP代码提取到文件中，然后使用Windiff之类的工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|871177|或者，如果您必须在数据库中执行此操作，请查看these+tools。|offset|length|871178|将来，将您的SP脚本放入源代码控制中。您可以对更改进行分支和合并。|871179|entityMap|0|LINK|mutability|MUTABLE|url|http://en.wikipedia.org/wiki/Microsoft_SQL_Server_Compare_Tools^0|0|M|B|0|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|Q|8|@]|9|@$D|R|E|S|1|T]]|A|$]]|$1|F|3|G|5|6|7|U|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|V|8|@]|9|@]|A|$]]]|I|$J|$5|K|L|M|A|$N|O]]]]

Ouch, this is something you should have considered earlier. One approach: extract the SP code to files and use a tool like Windiff.

Or if you have to do it in the database, check out <a href="http://en.wikipedia.org/wiki/Microsoft_SQL_Server_Compare_Tools" rel="nofollow noreferrer">these tools</a>.

In the future, put your SP scripts into source control. You could have branched and merged the changes.

blocks|key|871261|text|我建议购买(或者只是评估)一个专用的工具来实现这一点。市场上有许多产品，包括：Apex+SQL+Diff和Redgate+SQL+Compare|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|871262|我使用Apex+SQL+Diff已经有很多年了，我会全心全意地推荐它。|871263|entityMap|0|LINK|mutability|MUTABLE|url|http://www.apexsql.com/sql_tools_diff.asp|1|http://www.red-gate.com/products/SQL_Compare/index.htm^0|13|D|0|1H|J|1|0|0^^$0|@$1|2|3|4|5|6|7|P|8|@]|9|@$A|Q|B|R|1|S]|$A|T|B|U|1|V]]|C|$]]|$1|D|3|E|5|6|7|W|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|X|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]|N|$5|I|J|K|C|$L|O]]]]

I would recommend purchasing (or just evaluating) a dedicated tool to achieve this. There are a number of products on the market including:
<a href="http://www.apexsql.com/sql_tools_diff.asp" rel="nofollow noreferrer">Apex SQL Diff</a> and <a href="http://www.red-gate.com/products/SQL_Compare/index.htm" rel="nofollow noreferrer">Redgate SQL Compare</a>

I have used Apex SQL Diff for a number of years and would wholeheartedly recommend it.

blocks|key|4089985|text|Visual+Studio中可用的功能之一是模式比较，它将比较所有数据库对象，如表、视图、sprocs等。不确定您是否可以使用该工具。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4089986|另一个功能允许您比较数据库中的数据，这已经是一个救世主。|4089987|entityMap^0|0|0^^$0|@$1|2|3|4|5|6|7|F|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|G|8|@]|9|@]|A|$]]|$1|D|3|-4|5|6|7|H|8|@]|9|@]|A|$]]]|E|$]]

One of the features available inside of Visual Studio is called Schema Compare which will compare all database objects such as tables, views, sprocs, etc. Not sure if you have that tool available to you or not.

Another feature allows you to compare the data in the databases which has been a savior already.

blocks|key|1301912|text|要想知道什么时候发生了变化，可以使用下面的命令：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1301913|SELECT
++++CONVERT(varchar(23),modify_date,121)+AS+modify_date
++++++++,type_desc
++++++++,name
++++FROM+sys.objects
++++WHERE+is_ms_shipped=0
++++ORDER+BY+1+DESC|code-block|syntax|javascript|1301914|它将列出以下类型的项目：|1301915|CHECK_CONSTRAINT
DEFAULT_CONSTRAINT
FOREIGN_KEY_CONSTRAINT
PRIMARY_KEY_CONSTRAINT
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
UNIQUE_CONSTRAINT
USER_TABLE
VIEW|1301916|此外，您可能希望查看CVS或sourcesafe之类的内容，这样您就可以签出/签入代码，并具有合并/分支功能。|1301917|脚本一切分离的文件，并使用一个工具，如超越比较(有一个免费试用)+http://www.scootersoftware.com/moreinfo.php它可以比较目录，并允许您查看每个文件的差异，合并功能，等等。|offset|length|1301918|entityMap|0|LINK|mutability|MUTABLE|url|http://www.scootersoftware.com/moreinfo.php^0|0|0|0|0|0|X|17|0|0^^$0|@$1|2|3|4|5|6|7|Y|8|@]|9|@]|A|$]]|$1|B|3|C|5|D|7|Z|8|@]|9|@]|A|$E|F]]|$1|G|3|H|5|6|7|10|8|@]|9|@]|A|$]]|$1|I|3|J|5|D|7|11|8|@]|9|@]|A|$E|F]]|$1|K|3|L|5|6|7|12|8|@]|9|@]|A|$]]|$1|M|3|N|5|6|7|13|8|@]|9|@$O|14|P|15|1|16]]|A|$]]|$1|Q|3|-4|5|6|7|17|8|@]|9|@]|A|$]]]|R|$S|$5|T|U|V|A|$W|X]]]]

to find when things changed use this:

<pre><code>SELECT
 CONVERT(varchar(23),modify_date,121) AS modify_date
 ,type_desc
 ,name
 FROM sys.objects
 WHERE is_ms_shipped=0
 ORDER BY 1 DESC
</code></pre>

it will list the following types of items:

<pre><code>CHECK_CONSTRAINT
DEFAULT_CONSTRAINT
FOREIGN_KEY_CONSTRAINT
PRIMARY_KEY_CONSTRAINT
SQL_SCALAR_FUNCTION
SQL_STORED_PROCEDURE
SQL_TABLE_VALUED_FUNCTION
SQL_TRIGGER
UNIQUE_CONSTRAINT
USER_TABLE
VIEW
</code></pre>

Also, you might want to look into something like CVS or sourcesafe, so you can check out/in code and have merge/branch capabilities.

script everything to separate files and use a tool like Beyond Compare (has a free trial) <a href="http://www.scootersoftware.com/moreinfo.php" rel="nofollow noreferrer">http://www.scootersoftware.com/moreinfo.php</a> It can compare directories and allow you to view diffs per file too, with merge capabilities, etc.

blocks|key|1299500|text|大家好。我考虑了所有的回复，下载新软件对我来说不是一个选择。在进一步的研究中，这就是我对这个解决方案的看法。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1299501|我简单地查询了两个数据库，以获得所有存储过程及其最近的修改日期的列表。然后，我比较了它们的更改日期，并手动查看了它们的源代码，然后进行了更改。源代码控制肯定会对此有所帮助，但有时事情超出了我的控制范围。|1299502|获取所有SP名称列表并更改日期的代码如下所示。|1299503|select+ROUTINE_NAME,+LAST_ALTERED
from+information_schema.routines
WHERE
Routine_Type='procedure'
AND+specific_Catalog='DATABASE_NAME'+ORDER+BY+LAST_ALTERED|code-block|syntax|javascript|1299504|entityMap^0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|O|8|@]|9|@]|A|$]]|$1|F|3|G|5|H|7|P|8|@]|9|@]|A|$I|J]]|$1|K|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|L|$]]

Hey all. I took all of the responses into consideration and downloading new software is not an option for me. Upon further research, this is how I went about this solution.

I simply queried both databases for a list of all stored procedures and their most recent alter date. I then compared their alter date and manually looked at their source and made my changes. Source control definitely would have helped with this, but sometimes things are out of my control. 

The code to get a list of all of my SP names and alter dates is as follows.

<pre><code>select ROUTINE_NAME, LAST_ALTERED
from information_schema.routines
WHERE
Routine_Type='procedure'
AND specific_Catalog='DATABASE_NAME' ORDER BY LAST_ALTERED
</code></pre>

For an app my team is developing, I have created a copy of the database to work independently on some possible features for the system. In doing so, I have changed some stored procedures. Meanwhile, other members of the team continue to work on the other database and change some of those stored procedures. 

The code is still calling the same SP names, so I'll need to know which stored procedures have been changed in order to make the correct fixes. Is there any way to take all of the stored procedures from one database and match it against SPs with the same name in the other database, to see which are different (besides the USES[DB1] and USES [DB2] difference).

Thanks

Syncing stored procedures between two databases?

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

对于我的团队正在开发的一个应用程序，我已经创建了一个数据库副本，以便独立处理系统的一些可能功能。在此过程中，我更改了一些存储过程。同时，团队的其他成员继续在另一个数据库上工作，并更改其中一些存储过程。代码仍然调用相同的SP名称，因此我需要知道哪些存储过程发生了更改，以便进行正确的修复。有没有办法从一个数据库中提取所有存...

问在两个数据库之间同步存储过程？
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问在两个数据库之间同步存储过程？EN