数据库比较工具
有人使用过数据库比较工具吗？ 您会推荐哪一款？
我们目前正在使用 Redgate 的“SQLCompare”，但我很想知道市场上是否有更好的工具。
主要要求是他们应该能够将脚本文件夹与实时数据库进行比较。
谢谢， 迪米
Has someone experience with database comparison tools?
Which one you would recommend?
We are currently using "SQLCompare" from Redgate, but I am curious to know if there are better tools on the market.
The main requirement is that they should be able to compare scripts folder against a live database.
Thanks,
Dimi
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（7）
SQL Compare 相当不错。 我还使用了 SQL Delta，它提供了更好的增量脚本。 此外，如果您是 Visual Studio 用户，Visual Studio Team System Database Edition 也是一个不错的选择（包括用于自动化数据库构建和版本控制的 MSBuild 任务）。 如果您获得 VSTS Developer 版本的许可，VSTS DB（又名数据家伙）现在也是免费的。
SQL Compare is pretty good. I've also used SQL Delta which provided better delta scripts. Also if you are a visual studio user, Visual Studio Team System Database Edition is not a bad way to go (includes MSBuild tasks to automate your DB builds and versioning). And VSTS DB (aka data dude) is also free now if you are licensed for VSTS Developer edition.
我在 Innovartis 工作，我们制作了 DB Ghost，您可能想看看。 它可以做你想做的事 - 将脚本与数据库进行比较。 它可以使用变更管理器通过构建和比较一步完成此操作。 它非常非常快。 构建数据库还为您提供了数据库依赖性检查的额外好处，以防万一有人通过更改或引入另一段数据库代码破坏了一段数据库代码。 我们相信该软件提供了一种快速且经济高效地管理数据库更改的方法，并且与源代码控制相结合可以为您提供全面的控制。 类似于团队系统，但便宜得多。
编写脚本、构建、比较、升级、创建更改脚本、部署和 复制数据库功能，免费。 www.dbghost.com
I work for Innovartis and we make DB Ghost which is something you may want to look at. It can do what you want - compare scripts to a database. It can do this in a single step using the change manager by building and comparing. It is very, very fast. Building the database also gives you the added benefit of dependency checking of the database just in case someone has broken one piece of database code by changing or introducing another. We believe the software offers a way to manage database changes quickly and cost effectively and combined with your source control can give you total control. Like team system but much, much cheaper.
Script, Build, Compare, Upgrade, Create a change script, Deploy, & Copy database function which is free. www.dbghost.com
Redgate 的 SQL Compare 是我用于数据库比较的最佳工具。
SQL Compare by Redgate is the best tool I've used for db compare.
我已经使用 AdeptSQL 工具很多年了，并且给我留下了深刻的印象。 他们也有很好的支持，上次我看的时候他们的价格也很合理。
I've been using the AdeptSQL tool for many years and have been very impressed. They have very good support too, and last time I looked they were reasonably priced.
TOAD for SQL Server 中有一个不错的比较工具。 它是独立的免费应用程序，但现在它只是完整包的一部分。 但你可以尝试测试版。 您可以制作结构快照，并随时将实时服务器与快照进行比较。
Nice compare tool is inside TOAD for SQL server. It was standalone free application, but now it is only part of full package. But you can try beta version. You can make snapshot of structure and anytime compare live server against snapshot.
我们可以向您推荐一款可靠的 SQL 比较工具，它可以将表的比较和同步速度提高 3 倍SQL Server 数据库中的数据。 它是用于 SQL Server 的 dbForge 数据比较。
主要优点：
加上免费 30 天试用和无风险购买30天退款保证。
We can recommend you a reliable SQL comparison tool that offer 3 times faster comparison and synchronization of table data in your SQL Server databases. It's dbForge Data Compare for SQL Server.
Main advantages:
Plus free 30-day trial and risk-free purchase with 30-day money back guarantee.
我真的很喜欢 Apex SQL 工具 - 我是否喜欢 Red-Gate 总是有点犹豫不决或用于相同工作的 Apex 工具:-)
I really like the Apex SQL tools - it's always a bit of a toss-up whether I prefer the Red-Gate or the Apex tool for the same job :-)