Is there a nice tool that allows for easy comparison between 2 Sql-Server databases ?
是否有一个好的工具可以方便地比较两个Sql-Server数据库?
For example, I'd like to do dev DB vs. live DB comparison to see what objects (view, stored procedures, tables ...) have been modified in dev.
例如，我想对dev DB和live DB进行比较，看看在dev中修改了哪些对象(视图、存储过程、表…)。
I know I can just run a script that compares system files, but I am hoping there is something nicer out there.
我知道我可以运行一个比较系统文件的脚本，但是我希望有更好的东西。
2 个解决方案
#1
3
There's lots of options:
有很多选项:
Red Gate SQL Compare is my favorite, but ApexSQL has one (SQL Diff) as well. Also, Nob Hill Software has one.
Red Gate SQL比较是我的最爱，但ApexSQL也有一个(SQL Diff)。另外，Nob Hill软件也有一个。
#2
0
If your DB has a way to dump its definitions without the data to a text file, the diff tool would be a low tech way to solve this.
如果您的DB有一种方法可以将它的定义转储到文本文件中，而不需要将数据转储到文本文件中，那么diff工具将是一种技术含量较低的方法来解决这个问题。
Might not be ideal, but all the tools you need will very often already be installed on your server.
可能并不理想，但是您需要的所有工具通常都已经安装在您的服务器上了。
Short answer as I'm on the phone, sorry.
我在打电话时简短的回答，抱歉。
#1
3
There's lots of options:
有很多选项:
Red Gate SQL Compare is my favorite, but ApexSQL has one (SQL Diff) as well. Also, Nob Hill Software has one.
Red Gate SQL比较是我的最爱，但ApexSQL也有一个(SQL Diff)。另外，Nob Hill软件也有一个。
#2
0
If your DB has a way to dump its definitions without the data to a text file, the diff tool would be a low tech way to solve this.
如果您的DB有一种方法可以将它的定义转储到文本文件中，而不需要将数据转储到文本文件中，那么diff工具将是一种技术含量较低的方法来解决这个问题。
Might not be ideal, but all the tools you need will very often already be installed on your server.
可能并不理想，但是您需要的所有工具通常都已经安装在您的服务器上了。
Short answer as I'm on the phone, sorry.
我在打电话时简短的回答，抱歉。