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
109 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.6 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

Toad for Oracle

Toad for Oracle is very well suited for all Oracle implementations, be it single instance or RAC. It is best suited for use of Oracle DBA, Developer and Database Engineers.I don't recommend Toad for Oracle for Project Managers or Solution Architects. This can be a pricier choice for these people. They can do fine with free options like SQL Developer.
Ravinder Gupta | TrustRadius Reviewer

Feature Rating Comparison

Database Development

dbForge Data Compare for MySQL
8.0
Toad for Oracle
7.8
Database change management
dbForge Data Compare for MySQL
8.0
Toad for Oracle
7.6
Version control tools
dbForge Data Compare for MySQL
Toad for Oracle
7.9
Test data generation
dbForge Data Compare for MySQL
Toad for Oracle
7.1
Performance optimization tools
dbForge Data Compare for MySQL
Toad for Oracle
8.0
Schema maintenance
dbForge Data Compare for MySQL
Toad for Oracle
8.3

Database Administration

dbForge Data Compare for MySQL
Toad for Oracle
8.0
User management
dbForge Data Compare for MySQL
Toad for Oracle
7.9
Database security
dbForge Data Compare for MySQL
Toad for Oracle
7.8
Database status reporting
dbForge Data Compare for MySQL
Toad for Oracle
8.1
Change management
dbForge Data Compare for MySQL
Toad for Oracle
8.3

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

Toad for Oracle

  • Toad is a de-facto standard tool for data developers and analysts. Generally speaking it provides almost every function needed to manage data in EDW with great performance and stability.
  • The nature of clinical data is big-sized: one table may have billions of rows. Toad provides critical functions to manage SQLs, e.g. Top SQL that can monitor and manage SQLs using CPU power and network bandwidth, so that EDW administrator can optimize ETL operations in the best efficiency.
  • Many of our data analysts are not computer science backgrounded (having clinical / nursing background). Toad provides great auditing tools such as Tuning Lab or SQL Scanner, so that data analysts can train themselves with guidance of the tool.
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

Toad for Oracle

  • The date/time settings in Toad are kind of difficult to figure out. I have to use an ALTER SESSION command to format the dates so I can actually query date/time fields.
  • It seems to be updated too often. I get notifications very frequently about new versions being available.
  • The export function is difficult to use.
Aaron Baker | TrustRadius Reviewer

Likelihood to Renew

dbForge Data Compare for MySQL

No score
No answers yet
No answers on this topic

Toad for Oracle

Toad for Oracle 9.0
Based on 1 answer
It is the preferred tool for our organization.
Anonymous | TrustRadius Reviewer

Usability

dbForge Data Compare for MySQL

No score
No answers yet
No answers on this topic

Toad for Oracle

Toad for Oracle 9.0
Based on 2 answers
I give is an 8 because nothing is a 10 and there is always room for improvement. I believe the user who is not as technologically inclined would be better suited with an easier way to identify the options for setting the layout up for Toad's GUI. To some it is very cumbersome and confusing.
Anonymous | TrustRadius Reviewer

Support Rating

dbForge Data Compare for MySQL

No score
No answers yet
No answers on this topic

Toad for Oracle

Toad for Oracle 7.2
Based on 7 answers
I give the overall support for Toad for Oracle a 10/10. This is because whenever there has been an issue with this software, our team has got an immediate response. The same can not be said for similar software. The most recent example of this is when we needed to renew our licenses. Some employees were unable to log in to code with the given license key. Support was able to resolve the issue quickly.
Jatel Desai | 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

Toad for Oracle

Toad is much better than Tableau query writer. Tableau is not intuitive and requires knowledge of proprietary database language to fully implement. Tableau does not perform as quickly and accurately as Toad. Toad is very easy and slim to install. Additional hardware is often required to run Tableau smoothly. Support for Tableau is even more expensive than Toad support.
Maurice Samuels | 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

Toad for Oracle

  • Quick and easy query development helps reduce man-hours in a project which converts to real dollars.
  • Query analysis and tuning result in low database overhead and low latency, thus translating into real dollars because a system can thus handle more requests from customers.
  • Ease of use makes it easy to deploy greenhorns in projects with minimal training, thus helping save money. Otherwise menial and simple jobs would have required experienced DBAs.
Dhruba Jyoti Nag | 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

Toad for Oracle

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
Toad for Oracle
8.3

Likelihood to Renew

dbForge Data Compare for MySQL
Toad for Oracle
9.0

Usability

dbForge Data Compare for MySQL
Toad for Oracle
9.0

Support Rating

dbForge Data Compare for MySQL
Toad for Oracle
7.2

Add comparison