前后数据库差异，导出db到txt
我必须看到同一数据库（MS SQL 2008）的两种状态之间的差异。 Profiler 不是一个选项，因为它是运行时工具并且需要操作员操作。
我还没有找到用于此目的的工具，所以问题是 - 有没有办法将数据库数据导出为人类可读的文本格式，以便将它们与像windiff这样的东西进行比较？
问候，
I have to see a difference between 2 states of the same DB (MS SQL 2008). Profiler is not an option as it is run-time tool and needs operator actions.
I have not found tools for this purpose, so the question is - is there a way to export DB data into human-readable text format to compare them with something like windiff?
Regards,
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
我知道 redgate 提供了一种产品来执行 Schema 和 数据差异。我个人从未使用过它，但我看过各种演示，听起来它可能可以满足您的需要。 SQL Server 2005 附带了一个名为 TableDiff，它允许您比较两个表，如果需要，您可以编写脚本来比较更多表。
I know redgate offers a product to do a Schema and a Data differential. I've personally never used it, but I've seen various demos and it sounds like it might do what you need. There is also a utility that came with SQL Server 2005 called TableDiff, that lets you compare two tables that you could probably script to compare more if needed.