Reliable MS SQL Data Comparison and Synchronization Tool
- Compare and synchronize database tables
- Visualize the differences between compared tables
- Use custom-defined comparison keys
- Map tables and columns regardless of their names
- Project-oriented architecture: save your comparison plan
- Automate data synchronization with command-line utility
Datanamic DataDiff for MS SQL is a professional grade, easy-to-use MS SQL Server tool that compares and synchronizes data of two MS SQL Server databases. The tool enables users to synchronize the data in complete databases or selected tables with just a few mouse clicks. Set up your comparison plan with flexible comparison options, compare the databases, navigate through the differences in an intuitive differences grid, and safely synchronize all or only a selection of records. A command line utility is available to automate your data compare and synchronize process.
What Can Datanamic DataDiff for MS SQL Do For Me?
Datanamic DataDiff for MS SQL can be used for synchronizing data, data auditing, data migrations, verification of (corrupt) data etc.
Who Should Use Datanamic DataDiff for MS SQL?
Datanamic DataDiff for MS SQL can be used by database administrators, developers, testers that need a quick, easy and reliable way to compare and synchronize MS SQL Server database data.
Datanamic DataDiff for MS SQL Server compares data in selected tables from two databases. After comparison, you can synchronize.
MS SQL Server Connectivity
- Direct access to MS SQL databases (with native driver).
- Support for multiple MS SQL Server versions.
Supported MS SQL versions: 2000, 2005, 2008, 2012, 2014 and 2016.
- Cross database version comparison.
Comparison and synchronization across database versions is supported. e.g. compare a MS SQL 2008 database with a MS SQL 2016 database.
- Compare selected tables.
Compare complete MS SQL databases or a selection of tables.
- Compare selected fields.
You don't have to compare all fields in a table. You can define which fields to compare. Unique is that that does not mean that you cannot synchronize excluded fields. You can always synchronize a field, even if it was not included in the list of fields to compare.
- Cross version comparison and synchronization.
Comparison and synchronization can occur between two different MS SQL Server versions.
- Define custom comparison keys.
A comparison key is automatically selected if your tables contain a matching unique key. You can also define your own comparison key (any combination of the fields of that table).
- Comparison options.
Control the way data is compared. Ignore spaces, trim strings, match NULL to empty string, case-insensitive comparison, etc.
- Fast comparison of large databases.
Optimized memory usage and comparison routines make Datanamic DataDiff for MS SQL Server one of the fastest products for large databases.
- Supports comparing binary data.
Special routines guarentee fast comparison of binary data. The comparison results grid includes a special viewer for binary fields.
- Data filtering with WHERE clauses.
You can define a where clause on each source and/or destination table.
- Compare fields with different data types.
When the data types in the fields to compare differ, the data is automatically converted in such a way that they can be compared.
- Mapping tables and columns.
Tables and columns are automatically mapped based on their names. You can manually map any table and column.
- Export comparison results.
- Export all or selected comparison results to one or more CSV files.
- Synchronize directly on database or generate a update script.
- Refertial integrity support.
Datanamic DataDiff for MS SQL handles data dependencies and referential integrity during comparison and synchronization. To speed up synchronization you have got the option to disable foreign keys during synchronization.
- Partial synchronization.
Partial synchronization allows you to synchronize only selected columns and/or only selected records.
- Synchronize binary data.
Synchronization fo binary data is supported when you synchronize directly on the database.
- Warnings on record level for potential errors during synchronization.
Warnings appear in the comparison results grid when synchronization might lead to invalid data. This is the case when the destination field for example requires a value but the value that is gonna be inserted is a NULL value.
- Exclude fields for synchronization on project level.
In the project options dialog you can define a list of field names for fields you don't want to synchronize. This way you don't have to exclude those fields manually. This is very useful to exclude columns used for auditing purposes.
- Quick overview of differences.
Easy-to-use navigation through the color-coded data differences.
- Automated comparison and synchronization.
A command line utility is included to automate your data compare and synchronize process.
- Clear user interface.
Save your data comparison plan to a DataDiff project for later re-use.
- Detection of metadata changes.
You do not have to reconfigure your complete compare plan when the structure of a source or destination table has changed. Datanamic DataDiff for MS SQL will do that for you automatically.
Start synchronizing the two databases. Generate an update script or update the database records directly.
Datanamic DataDiff for MS SQL costs $ 299 for a single user license (EULA).
Upgrade Protection/Support is optional and costs 20% of the initial purchase price per year.
Operating System: Windows 10/8.1/8/7/Vista/XP
Memory: 1 GB minimum (2 GB recommended)
Hard Disk: At least 20 MB of free disk space
Databases: MS SQL Server 2000, 2005, 2008, 2012, 2014, 2016