The structure and data comparison of MS SQL Server database

Key words: SQL Server, table structure comparison, data comparison, data by row comparison

Brief introduction

The Database Data Comparison tool (MSSQL edition) is a gadget for MS SQL Server that compares table structure and data for two of data.

1. Table structure Comparison: such as the structure and data synchronization between the development library and the formal library, this tool can tell you which table structure has a decrease in the field, or change the field type, and generate SQL for the structure synchronization.

2, data comparison: For example, compare the data difference of a table in two database, the difference rows are marked with color, and SQL script can be generated to synchronize two libraries.

: Http://www.vidarsoft.cn/download/SQLDiff.zip

csdn:http://download.csdn.net/detail/swordmanli/9629605

Operating Environment

1. Executable program SQLDiff.exe

2, need. NET framework4.0, if there is no environment, please download the installation first

Operation diagram:

To set up a data source for a specific operation

After the download is complete, unzip.

Run:

To set up a data source:

After the point is determined, you can display a table of differences between the two databases, as shown in the Red row.

Table structure Comparison

By clicking the structure behind the line, you can compare the differences between table structures in detail and form SQL scripts that are executed after the user points are determined.

After the point is determined, the execution succeeds and the table structure in the target table changes.

The fields in the table can also be synchronized, such as:

For example, the field differences in the Dept table can also be checked out and formed into a script for synchronization.

Data comparison

Select a table, and then point to "more than data", such as.

Then, as you can see, the distinguished data is identified in red, and the two rows of data are compared together, and the difference data is distinguished by color.

Generate a modified script, such as.

The structure and data comparison of MS SQL Server database