比较两个 SQL Server 数据库（架构和数据）的最佳工具是什么？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/685053/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
What is best tool to compare two SQL Server databases (schema and data)?
提问by Tomasz Smykowski
I would like to compare two SQL Server databases including schema (table structure) and data in tables too. What is best tool to do this?
我想比较两个 SQL Server 数据库，包括架构（表结构）和表中的数据。什么是最好的工具来做到这一点？
采纳答案by Joakim Backman
I am using Red-Gate's software: http://www.red-gate.com
我正在使用 Red-Gate 的软件：http: //www.red-gate.com
回答by Konstantin Tarkus
I use schema and data comparison functionality built into the latest version Microsoft Visual Studio 2015Community Edition (Free) or Professional / Premium / Ultimate edition. Works like a charm!
我使用最新版本Microsoft Visual Studio 2015社区版（免费）或专业版/高级版/旗舰版中内置的架构和数据比较功能。奇迹般有效！
http://channel9.msdn.com/Events/Visual-Studio/Launch-2013/VS108
http://channel9.msdn.com/Events/Visual-Studio/Launch-2013/VS108
Red-Gate's SQL data comparison toolis my second alternative:
Red-Gate 的 SQL 数据比较工具是我的第二个选择：
(source: spaanjaars.com)
（来源：spaanjaars.com）
回答by Tomasz Smykowski
I like Open DBDiff.
我喜欢Open DBDiff。
While not the most complete tool, it works great, it's free, and it's very easy to use.
虽然不是最完整的工具，但它运行良好、免费且非常易于使用。
回答by Sean Cleaver
SQL Admin Studiofrom http://www.simego.com/Products/SQL-Admin-Studiois now free, lets you manage your SQL Database, SQL Compare and Synchronise, Data Compare and Synchroniseand much more. Also supports SQL Azure and some MySQL Support too.
来自http://www.simego.com/Products/SQL-Admin-Studio 的SQL Admin Studio现在是免费的，让您可以管理您的 SQL 数据库、SQL 比较和同步、数据比较和同步等等。还支持 SQL Azure 和一些 MySQL 支持。
[UPDATE: Yes I am the Author of the above program, as it's now Free I just wanted to Share it with the community]
[更新：是的，我是上述程序的作者，因为它现在是免费的，我只是想与社区分享]
回答by Christopher Klein
I'm partial to AdeptSQL. It's clean and intuitive and it DOESN'T have the one feature that scares the hell out of me on a lot of similar programs. One giant button that it you push it will automatically synchronize EVERYTHING without so much as a by-your-leave. If you want to sync the changes you have to do it yourself and I like that.
我偏爱AdeptSQL。它干净且直观，而且它没有让我在许多类似程序中感到害怕的一项功能。一个巨大的按钮，你按下它会自动同步一切，而无需提前离开。如果你想同步你必须自己做的更改，我喜欢这样。
回答by Milind Thakkar
There is one tool with source code available at http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool
http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool 上提供了一种带有源代码的工具
That should give flexibility as code is available.
由于代码可用，这应该提供灵活性。
回答by Bluephlame
dbghostis the best i have used to date. one of the best features i have seen is that it will generate SQL code to go between versions of a database based on the SQL you keep in source control, as well as a database. simple and easy to use.
dbghost是我迄今为止用过的最好的。我见过的最好的功能之一是它会生成 SQL 代码，以根据您在源代码管理中保留的 SQL 以及数据库在数据库的版本之间切换。简单易用。
回答by JonoW
I've used SQL Delta before (http://www.sqldelta.com/), it's really good. Not free however, not sure how prices compare to Red-Gates
我以前使用过 SQL Delta ( http://www.sqldelta.com/)，它真的很好。但是不是免费的，不确定价格与 Red-Gates 相比如何
回答by Melad
Try DBComparer, it's free and fast:
试试 DBComparer，它是免费且快速的：
回答by Hugues Van Landeghem
Database Workbench can made it too
数据库工作台也可以做到
http://www.upscene.com/products.dbw.index.php
http://www.upscene.com/products.dbw.index.php
Cross database development
Use the Schema Compare and Migration Tools to compare testing and deployed databases, migrate existing databases to different database systems.
跨数据库开发
使用模式比较和迁移工具比较测试和部署的数据库，将现有数据库迁移到不同的数据库系统。
you can also made it with database Comparer
你也可以用数据库比较器制作它
http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp
http://www.clevercomponents.com/products/dbcomparer/dbcomparer.asp
I use it for Firebird and it works well.
我将它用于 Firebird，效果很好。
