Compare data in your tables
It's easy to compare data in tables and databases with the Database Workbench. If you need to check whether data has changed, been added or deleted, the Data Compare tool will be your favorite.
Want to sync your databases? A script can be generated for you. It's that easy. And yes, this works for different types of database systems too!
- Compare one database against another
- Check the results in the easy-to-use interface
- Create a change script
Easy to use
The Data Compare tool is easy to use. Connect to both source and destination, let the Data Compare automatically figure the order of the destination tables based on foreign key constraints and link source tables to their destination counterparts. By default, the primary key columns will be used as record identifiers.
You can automatically map source items to destination items, with a case insensitive fuzzy match of object names.
You can also manually drag and drop tables and columns to link them together.
The connection selection and mappings can be saved to a file so you can perform the same comparison later on.
Detailed results
There's detailed results after the compare process has finished. For each mapped comparison, a summary is shown in the list. You can select the comparison item for more details.
The details are displayed on tabs with new, modified and deleted table records. You can view the record data to see what the changes are.
