What users are saying about
5 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 7.9 out of 100
2 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9 out of 100

Likelihood to Recommend

dbForge Data Compare for MySQL

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.
Anthony Aziz | TrustRadius Reviewer

Assure MIMIX

MIMIX is well suited when the organization requires a PLANNED Switch.MIMX will also work for any unplanned switches. However, this is not the most ideal situation and we have had to perform at least once when the older iSeries hardware failed, and the business transactions were on hold, impacting the business. MIMIX support was required to be called upon to assist. We were able to get the new iSeries online within an hour, so thankfully the outage to the business was miminal. It is important that any organization utilizing MIMIX schedule, prepare, and plan for the PLANNED Switch, at least once per year, if not twice per year.
Anonymous | TrustRadius Reviewer

Feature Rating Comparison

Database Development

dbForge Data Compare for MySQL
8.0
Assure MIMIX
8.0
Database change management
dbForge Data Compare for MySQL
8.0
Assure MIMIX
8.0
Version control tools
dbForge Data Compare for MySQL
Assure MIMIX
8.0
Test data generation
dbForge Data Compare for MySQL
Assure MIMIX
8.0
Performance optimization tools
dbForge Data Compare for MySQL
Assure MIMIX
8.0
Schema maintenance
dbForge Data Compare for MySQL
Assure MIMIX
8.0

Database Administration

dbForge Data Compare for MySQL
Assure MIMIX
8.0
User management
dbForge Data Compare for MySQL
Assure MIMIX
8.0
Database security
dbForge Data Compare for MySQL
Assure MIMIX
8.0
Database status reporting
dbForge Data Compare for MySQL
Assure MIMIX
8.0
Change management
dbForge Data Compare for MySQL
Assure MIMIX
8.0

Pros

dbForge Data Compare for MySQL

  • 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
Anthony Aziz | TrustRadius Reviewer

Assure MIMIX

  • Redundancy - needs to be available at a moment's notice.
  • Protection - the business would be greatly impacted, therefore protection of production systems is key to the business succeeding.
  • Usability - needs to be user-friendly, easy to navigate and operate, as it will be required at any given time.
Anonymous | TrustRadius Reviewer

Cons

dbForge Data Compare for MySQL

  • Comparison can be very slow on large datasets.
  • Comparing records that are *different* is clunky, especially for tables with many fields.
Anthony Aziz | TrustRadius Reviewer

Assure MIMIX

  • Web interface needs some improvement. I can't recall the exact issue, but I do remember having to refresh the screen every now and then to see the update results as expected.
  • Overall, there were some known bugs in the version the organization was utilizing. These were reported and know to be bugs and hopefully resolved in future release.
Anonymous | TrustRadius Reviewer

Alternatives Considered

dbForge Data Compare for MySQL

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.
Anthony Aziz | TrustRadius Reviewer

Assure MIMIX

We used MIMIX for its role for iSeries high availability. We used Double Take by Vision Solutions for our production Windows environment. MIMIX is designed for iSeries, and Double Take was designed for Windows. We had VMware virtual environment, running multiple VMs for production ERP Lawson M3, now Infor. Both MIMIX and Double Take played the role well for what needed to be done. Without either MIMIX or DoubleTake, the business would have been impacted.
Anonymous | TrustRadius Reviewer

Return on Investment

dbForge Data Compare for MySQL

  • 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.
Anthony Aziz | TrustRadius Reviewer

Assure MIMIX

  • MIMIX had a positive impact, as the organization has had to rely upon the unplanned switch.
  • MIMIX definite must if organization is running i Series, and business needs are 24/7.
  • Without MIMIX in place, the downtime impact to the business would have been great.
Anonymous | TrustRadius Reviewer

Pricing Details

dbForge Data Compare for MySQL

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Assure MIMIX

General

Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No

Rating Summary

Likelihood to Recommend

dbForge Data Compare for MySQL
10.0
Assure MIMIX
8.0

Add comparison