Overall Satisfaction with dbForge Data Compare
Our dev team uses dbForge Data Compare for MySQL to sync data between pre-prod environments, look for differences in data for troubleshooting, and generate update scripts to sync other environments. Data Compare's comparisons can be customized for different scenarios and saved for re-used and sharing among the team. It also allows you to sync different sets of data between environments.
- Compare entire or subset of MySQL tables between databases
- Configure comparison rules
- Sync data between compared databases depending on differences
- Save comparison rules for reuse and sharing
- Break down differences between missing/new records, or different records
- See differences highlighted per field
- Execute sync immediately, or save as an SQL script file
- Command-line tool that can be used to add comparisons to deploy scripts
- Comparison can be very slow on large datasets.
- Comparing records that are *different* is clunky, especially for tables with many fields.
- Improve developer productivity by making data syncing quicker and easier.
- Reduce risk of deployment by ensuring data is in sync.
- Reduce issue resolution time by making "bad data" investigations quicker.
We haven't tried any other tools that do comparisons like Data Compare does. Our method prior to buying this tool was to manually run queries on each database and compare the output using text compare or by eye.
Data Compare covers two main use cases for us:
1) Keep data in sync between our development, test, and staging environments. When a full database import isn't practical, we will use Data Compare to sync data for key tables. We use this for configuration tables as well as operational test data.
2) Troubleshoot prod issues. When we have trouble reproducing user issues, Data Compare helps us compare our test environment data vs prod environment data to identify problems.