SQL Server差异工具 [英] SQL Server diff tool

问题描述

在一个团队中工作，人们很容易修改dev SQL Server表而忘了它，或者为部署做准备更改并不得不等待该部署。这样会使我们的开发人员表和活动表不一致，从而在将SPROC实时推送时会引起问题。

Working on a team where people are prone to amending dev SQL Server tables and forgetting about it, or preparing a change for deployment and having to wait for that deployment. This leaves our dev and live tables inconsistent, causing problems when SPROCs are pushed live.

有没有工具可以输入SPROC名称并检查所有引用的表

Is there a tool whereby I can enter a SPROC name and have it check all tables referenced in it in the dev and live DBs, and notify of any differences?

推荐答案

我知道两个出色的工具可用于区分SQL数据库结构-它们不会在文本中专门查看存储过程，但是会向您显示数据库中的结构差异：

I know two excellent tools for diffing SQL database structures - they don't specifically look inside stored procedures at their text, but they'll show you structural differences in your databases:

• RedGate < a href = http://www.red-gate.com/products/SQL_Compare/index.htm rel = noreferrer> SQL比较


• ApexSQL的 SQL差异

• RedGate SQL Compare
• ApexSQL's SQL Diff

Redgate还有一个 SQL依赖跟踪器，它可以可视化对象的依赖关系，并且可以在这里非常有用。

Redgate also has a SQL Dependency Tracker which visualizes object dependencies and could be quite useful here.

马克

这篇关于SQL Server差异工具的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！