dbForge Data Compare is a great tool for managing and syncing databases in multiple environments
July 12, 2019
dbForge Data Compare is a great tool for managing and syncing databases in multiple environments
Score 10 out of 10
Vetted Review
Verified User
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.
Pros
- 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
Cons
- 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.
Comments
Please log in to join the conversation