SQL Table Compare is an application that will compare the data in two database tables.
The program will show what rows were identical, different, and missing. The tool
generates SQL statements that can be used to synchronize the data in the tables.
The best part is that it is completely free!
Currently only Microsoft SQL Server is supported but addition database providers
could be very easily added. We plan to expand these capabilities in a future release.
If you can't wait the source is freely available.
SQL Table Compare is open source software (OSS). There is no license on this
(e.g. GPL), you are free to use the source for any purpose.
There are no warranties with this software, express or implied. Use at your own
risk and always preview the SQL synchronization statements before executing them.
Download
SqlTableCompare.zip 1.0.3 23 KB
.NET Framework 2.0 required - download
here.
Want the source? Send email to stc@w3enterprises.com.
Version History
1.0.1
Updated to fix a bug where the wrong column could be used to identify a row for updating.
1.0.2
Updated to identify columns with different values by changing the text to red.
1.0.3
Updated to:
- support Guids
- fix a PKey bug
- be compatible with SQL Azure
- allow the types of comparisons to be performed to be configured
- allow identical rows to be seen