什么是比较两个 SQL Server 数据库的免费工具? [英] What is a free tool to compare two SQL Server Databases?

问题描述

什么是比较两个 Sql Server 表(数据和架构)的免费工具.

What is a free tool to compare two Sql Server tables (data and schema).

如果该工具可以编写发现的差异，那就太好了.

It would be great if the tool can script the differences found.

我还浏览了一些较旧的帖子.我见过的最接近的是 SQLDBDiff，但我想尝试更多选择.

I also went through some older posts. The closest I have seen is SQLDBDiff but I would love to try more options.

推荐答案

TableDiff.exe 应该有你需要的一切.它是 SQL Server 2005 中隐藏的宝石之一.因此您无需下载任何内容.

TableDiff.exe should have everything you need. It is one of the hidden gems in SQL Server 2005. So you don't have to download anything.

• 表差异工具允许您发现和协调源表和目标表或视图之间的差异.Tablediff 实用程序可以报告架构和数据的差异.tablediff 最流行的特性是它可以生成一个脚本，您可以在目标上运行该脚本以协调表之间的差异.TableDiff.exe 需要 2 组输入；• 连通性——提供源和目标对象以及连通性信息.

• Table Difference tool allows you to discover and reconcile differences between a source and destination table or a view. Tablediff Utility can report differences on schema and data. The most popular feature of tablediff is the fact that it can generate a script that you can run on the destination that will reconcile differences between the tables. TableDiff.exe takes 2 sets of input; • Connectivity - Provide source and destination objects and connectivity information.

• 比较选项 - 选择比较选项之一• 比较模式:常规或严格

• Compare Options - Select one of the compare options • Compare schemas: Regular or Strict

• 使用行计数、哈希或列比较进行比较

• Compare using Rowcounts, Hashes or Column comparisons

• 使用 I/U/D 语句生成差异脚本以将目标同步到源.TableDiff 旨在用于复制，但可以轻松应用于需要比较数据和架构的任何场景.您可以在 SQL Server 2005 的联机丛书中找到有关命令行实用程序和 Tablediff 实用程序的更多信息.

• Generate difference scripts with I/U/D statements to synchronize destination to the source. TableDiff was intended for replication but can easily apply to any scenario where you need to compare data and schema. You can find more information about command line utilities and the Tablediff Utility in Books Online for SQL Server 2005.

这篇关于什么是比较两个 SQL Server 数据库的免费工具?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！