blocks|key|1381220|text|我使用的是红门公司的软件：http://www.red-gate.com|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1381221|entityMap|0|LINK|mutability|MUTABLE|url|http://www.red-gate.com/^0|D|N|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I am using Red-Gate's software:
 <a href="http://www.red-gate.com/" rel="noreferrer">http://www.red-gate.com</a>

blocks|key|1381582|text|我喜欢Open+DBDiff。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1381583|虽然不是最完整的工具，但它工作得很好，它是免费的，而且非常容易使用。|1381584|entityMap|0|LINK|mutability|MUTABLE|url|https://github.com/OpenDBDiff/OpenDBDiff^0|3|B|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

I like <a href="https://github.com/OpenDBDiff/OpenDBDiff" rel="nofollow noreferrer">Open DBDiff</a>.

While not the most complete tool, it works great, it's free, and it's very easy to use.

blocks|key|1596576|text|我偏爱AdeptSQL。它干净而直观，而且它没有在很多类似的程序中把我吓得要死的功能。只要你按下一个巨大的按钮，它就会自动同步所有东西，而不需要你的请假。如果你想同步这些改变，你必须自己去做，我喜欢这样。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1596577|entityMap|0|LINK|mutability|MUTABLE|url|http://www.adeptsql.com/^0|3|8|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I'm partial to <a href="http://www.adeptsql.com/" rel="nofollow noreferrer">AdeptSQL</a>. 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.

blocks|key|1596777|text|在http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool上有一个包含源代码的工具|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1596778|当代码可用时，这应该会提供灵活性。|1596779|entityMap|0|LINK|mutability|MUTABLE|url|http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool^0|1|26|0|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@$A|O|B|P|1|Q]]|C|$]]|$1|D|3|E|5|6|7|R|8|@]|9|@]|C|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|C|$]]]|G|$H|$5|I|J|K|C|$L|M]]]]

There is one tool with source code available at 
<a href="http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool" rel="noreferrer">http://www.codeproject.com/Articles/205011/SQL-Server-Database-Comparison-Tool</a>

That should give flexibility as code is available.

blocks|key|1381483|text|dbghost是我到目前为止用过的最好的。我见过的最好的特性之一是，它将生成SQL代码，以基于您在源代码控制中保存的SQL在数据库的不同版本之间切换，以及数据库。简单易用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1381484|entityMap|0|LINK|mutability|MUTABLE|url|http://www.innovartis.co.uk/^0|0|7|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

<a href="http://www.innovartis.co.uk/" rel="noreferrer">dbghost</a> is 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.

blocks|key|1596408|text|我以前用过SQL+Delta+(http://www.sqldelta.com/)，它真的很好。然而，不是免费的，不确定价格与Red-Gates相比如何|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1596409|entityMap|0|LINK|mutability|MUTABLE|url|http://www.sqldelta.com/^0|G|O|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I've used SQL Delta before (<a href="http://www.sqldelta.com/" rel="nofollow noreferrer">http://www.sqldelta.com/</a>), it's really good. Not free however, not sure how prices compare to Red-Gates

blocks|key|1596734|text|试试DBComparer，它是免费的，而且速度很快：|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1596735|http://dbcomparer.com/|offset|length|1596736|entityMap|0|LINK|mutability|MUTABLE|url^0|0|0|M|0|0^^$0|@$1|2|3|4|5|6|7|M|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|N|8|@]|9|@$D|O|E|P|1|Q]]|A|$]]|$1|F|3|-4|5|6|7|R|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|C]]]]

Try DBComparer, it's free and fast:

<a href="http://dbcomparer.com/" rel="nofollow">http://dbcomparer.com/</a>

blocks|key|1381299|text|我们使用的是内部开发的解决方案，它基本上是一个过程，其中包含您希望在比较中包含的参数(+SP、完整SP代码、表结构、默认值、索引、触发器)。等)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1381300|根据你的需要和预算，这也可能是一个很好的选择。|1381301|它也很容易开发，然后我们只需将过程的输出重定向到文本文件，并在文件之间进行文本比较。|1381302|它的一个好处是可以将输出保存在源代码控制中。|1381303|/B|1381304|entityMap^0|0|0|0|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|M|8|@]|9|@]|A|$]]|$1|D|3|E|5|6|7|N|8|@]|9|@]|A|$]]|$1|F|3|G|5|6|7|O|8|@]|9|@]|A|$]]|$1|H|3|I|5|6|7|P|8|@]|9|@]|A|$]]|$1|J|3|-4|5|6|7|Q|8|@]|9|@]|A|$]]]|K|$]]

We are using an inhouse developed solution that is basicly a procedure with arguments of what you want included in the comparision (SP's, Full SP code, table structure, defaults, indices, triggers.. etc)

Depending on your needs and budget, it might be a good way to go for you as well.

It is quite easily developed as well, then we just redirect output of procedure to textfiles and do text comparisions between the files.

One good thing about it is that its possible to save the output in source control.

/B

blocks|key|1596454|text|我用过Red+Gate的工具，它们非常棒。但是，如果您花不起钱，可以尝试使用Open+DBDiff来比较模式。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1596455|entityMap|0|LINK|mutability|MUTABLE|url|http://opendbiff.codeplex.com/^0|12|B|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I've used Red Gate's tools and they are superb.
However, if you can't spend any money you could try <a href="http://opendbiff.codeplex.com/" rel="nofollow noreferrer">Open DBDiff</a> to compare schemas.

blocks|key|1381659|text|如果你使用的是AdeptSQL，我绝对会选择它。它是我尝试过的工具中最不好看但最有才华的数据库比较工具。它可以比较结构和数据。它告诉您哪些表存在于一个数据库中而不存在于另一个数据库中，比较常见表的结构和数据，并生成脚本来同步这两个表。它不是免费的，但有30天的试用期(据我所知)|type|unstyled|depth|inlineStyleRanges|entityRanges|data|1381660|entityMap^0|0^^$0|@$1|2|3|4|5|6|7|D|8|@]|9|@]|A|$]]|$1|B|3|-4|5|6|7|E|8|@]|9|@]|A|$]]]|C|$]]

I would definitely go with AdeptSQL if you're using MSSQL. It's the least good looking but the most talented db compare tool amongst the ones I've tried. It can compare both the structure and the data. It tells you which tables exist on one db but does not exist on the other, compares the structure and data of the common ones and it can produce the script to synchronize the two. It's not free but has a 30 day trial (as far as I can remember)

blocks|key|1381714|text|我试过OpenDiff+Tool了。这是一个非常棒的工具，它免费且易于使用。|type|unstyled|depth|inlineStyleRanges|entityRanges|offset|length|data|1381715|entityMap|0|LINK|mutability|MUTABLE|url|http://www.ginktage.com/2012/04/open-dbdiff-for-sql-server-2008/^0|3|D|0|0^^$0|@$1|2|3|4|5|6|7|L|8|@]|9|@$A|M|B|N|1|O]]|C|$]]|$1|D|3|-4|5|6|7|P|8|@]|9|@]|C|$]]]|E|$F|$5|G|H|I|C|$J|K]]]]

I tried <a href="http://www.ginktage.com/2012/04/open-dbdiff-for-sql-server-2008/" rel="nofollow">OpenDiff Tool</a> . Great tool that is free and easy to use .

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?

What is best tool to compare two SQL Server databases (schema and data)?

SQL Server

数据库

我想比较两个SQL Server数据库，包括模式(表结构)和表中的数据。做这件事最好的工具是什么？

问比较两个SQL Server数据库(架构和数据)的最佳工具是什么？
EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问比较两个SQL Server数据库(架构和数据)的最佳工具是什么？EN

回答 11

Stack Overflow用户

Stack Overflow用户

Stack Overflow用户

社区

活动

资源

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问比较两个SQL Server数据库(架构和数据)的最佳工具是什么？
EN