免费的 SQL 比较工具
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/1352600/
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
Free SQL comparison tool
提问by kaivalya
I have been using SQL Compare by Redgate at my company and was very satisfied with it. Are there any free comparison tools that are similar? Or what would be my best shot for synchronizing two SQL db's without a paid application
我一直在我的公司使用 Redgate 的 SQL Compare 并且对它非常满意。有没有类似的免费比较工具？或者在没有付费应用程序的情况下同步两个 SQL 数据库的最佳方法是什么
采纳答案by Troy Hunt
I've gone through this and couldn't find anything comparable, free or otherwise. $395 is a very small price to pay for the value the tool brings and it will almost certainly pay for itself very quickly in productivity gains and risk minimisation.
我已经经历了这个并且找不到任何可比的，免费的或其他的。395 美元对于该工具带来的价值来说是一个非常小的代价，而且几乎可以肯定，它会很快在生产力提高和风险最小化方面收回成本。
回答by Jaimal Chohan
I had the same problem and wanted a free GUI base Schema comparer tool, what I found was Star Inix (http://www.starinix.com/sqlcompare02.htm). Obviously not as good as Redgates offering, but it does the job.
我遇到了同样的问题，想要一个免费的基于 GUI 的架构比较器工具，我发现的是 Star Inix ( http://www.starinix.com/sqlcompare02.htm)。显然不如 Redgates 提供的好，但它可以完成工作。
Also, with Redgate Sql Compare, once the trial period is over, if you enter the key as "i need more time" (without the quotes) you can extend the trial by a further 14 days.
此外，使用 Redgate Sql Compare，试用期结束后，如果您将密钥输入为“我需要更多时间”（不带引号），您可以将试用期再延长 14 天。
回答by Gokulnath
Visual Studio (Premium & above I guess) has this feature built-in under the SQL menu.
Visual Studio（我猜是 Premium 及更高版本）在 SQL 菜单下内置了此功能。
回答by CMerat
Very similar to RedGate's SQL Compare and free.
非常类似于 RedGate 的 SQL Compare 并且免费。
回答by RRUZ
You can try using TableDiff , that came with SQL Server 2005.
您可以尝试使用 SQL Server 2005 附带的 TableDiff 。
SQL Server 2005 TableDiff Utility
SQL Server 2005 TableDiff 实用程序
Bye.
再见。
回答by Cristian B
Have a look at Mighty Comparer. It's currently free. A professional version is under development.
看看Mighty Comparer。目前是免费的。专业版正在开发中。
回答by David Raznick
I normally go for the hackish but surprisingly effective technique of downloading the sys_informationtables to text files and diffing them with your favorite diff program (this way will even let you compare 3 schemas!).
我通常采用骇人听闻但非常有效的技术，将sys_information表下载到文本文件中，然后使用您最喜欢的 diff 程序将它们进行比较（这种方式甚至可以让您比较 3 个模式！）。
回答by Hugues Van Landeghem
You can use Database Comparer
您可以使用数据库比较器
Database Comparer is free for non-commercial use.
Database Comparer 可免费用于非商业用途。
