Top Rated
91 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.7 out of 100
16 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.3 out of 100

Likelihood to Recommend

Oracle Enterprise Manager

OEM is very well suited for all Oracle products, especially Oracle databases and Exadata machines; even not Oracle hardware, it is very good and displaying high level details.OEM is not well suited for older hardware vendors like AIX, HP-UX, DEC/Digital, Microsoft (sql server). This is a big negative as most large companies have a heterogeneous environment with many different vendor hardware and (database) software products.
Maurice Samuels | TrustRadius Reviewer

Redgate SQL Data Compare

If you plan to use Redgate Data Compare to automate data change between tables or SCD or similar, this is not the software that is right for you, Data Compare is a software that performs simply (but in an optimal manner) the comparison of data between tables of different databases on different environments or clone or mirror databases even on the same environment or server. Once the data is compared, you can select or deselect each line you want to update and then have the data alignment script prepared for it.
Luca Campanelli | TrustRadius Reviewer

Feature Rating Comparison

Monitoring Tasks

Oracle Enterprise Manager
8.6
Redgate SQL Data Compare
Remote monitoring
Oracle Enterprise Manager
9.1
Redgate SQL Data Compare
Network device monitoring
Oracle Enterprise Manager
7.2
Redgate SQL Data Compare
Multiple Server Monitoring
Oracle Enterprise Manager
9.4
Redgate SQL Data Compare
Multi-device monitoring
Oracle Enterprise Manager
8.9
Redgate SQL Data Compare
Automated alerts and notifications
Oracle Enterprise Manager
8.4
Redgate SQL Data Compare

Management Tasks

Oracle Enterprise Manager
7.6
Redgate SQL Data Compare
Patch Management
Oracle Enterprise Manager
7.1
Redgate SQL Data Compare
Service configuration management
Oracle Enterprise Manager
7.5
Redgate SQL Data Compare
Software and hardware inventory
Oracle Enterprise Manager
7.7
Redgate SQL Data Compare
Policy-based automation
Oracle Enterprise Manager
8.1
Redgate SQL Data Compare

Reporting

Oracle Enterprise Manager
8.0
Redgate SQL Data Compare
Performance data reports
Oracle Enterprise Manager
8.1
Redgate SQL Data Compare
Customizable reporting
Oracle Enterprise Manager
7.7
Redgate SQL Data Compare
Data visualization
Oracle Enterprise Manager
8.7
Redgate SQL Data Compare
Risk analysis
Oracle Enterprise Manager
7.6
Redgate SQL Data Compare

Security

Oracle Enterprise Manager
7.4
Redgate SQL Data Compare
Data backup and recovery
Oracle Enterprise Manager
8.3
Redgate SQL Data Compare
Antivirus and malware management
Oracle Enterprise Manager
6.2
Redgate SQL Data Compare
Adinistraor access control
Oracle Enterprise Manager
7.8
Redgate SQL Data Compare

Database Development

Oracle Enterprise Manager
Redgate SQL Data Compare
7.4
Version control tools
Oracle Enterprise Manager
Redgate SQL Data Compare
7.0
Test data generation
Oracle Enterprise Manager
Redgate SQL Data Compare
6.2
Performance optimization tools
Oracle Enterprise Manager
Redgate SQL Data Compare
7.0
Schema maintenance
Oracle Enterprise Manager
Redgate SQL Data Compare
8.0
Database change management
Oracle Enterprise Manager
Redgate SQL Data Compare
8.8

Database Administration

Oracle Enterprise Manager
Redgate SQL Data Compare
7.7
User management
Oracle Enterprise Manager
Redgate SQL Data Compare
6.0
Database security
Oracle Enterprise Manager
Redgate SQL Data Compare
7.0
Database status reporting
Oracle Enterprise Manager
Redgate SQL Data Compare
10.0
Change management
Oracle Enterprise Manager
Redgate SQL Data Compare
7.9

Pros

Oracle Enterprise Manager

  • Database status. Being able to see which databases are up/down, at a glance, allows us to quickly react to issues.
  • Reporting. We report on last backups, daily status, a host of metrics, and compliance levels of all our databases. With reporting we come into the office with a set of "status" reports and we know instantly if a database has issues.
  • Metrics. We have a number of KPI's and SLA's we need to meet. Metrics applied to the databases allow us to stay on top of those requirements as well as fix common issues without a DBA needing to log in to assess the issue.
Joseph Szupiany | TrustRadius Reviewer

Redgate SQL Data Compare

  • Simple and easy comparison of database data. Differences can be copied or synced from one database to another with a click of a button.
  • You can save "projects" so that you can easily rerun a previous comparison whenever you need to.
  • It has a very simple, easy to learn interface. I've never needed to read any documentation or watch any tutorials in order to figure out how to do something.
Richard Davies | TrustRadius Reviewer

Cons

Oracle Enterprise Manager

  • We also use OEM to monitor SQL Server. However, OEM only provided limited features for SQL Server. It would be nice if we can schedule backup jobs for SQL Server in OEM.
  • The ability to run SQL queries. You can't run queries in OEM. I have to go to SQL Developer or SQL PLUS to run. queries.
Anonymous | TrustRadius Reviewer

Redgate SQL Data Compare

  • Redgate SQL Data Compare is a bit slow for large text data comparison between the text fields of tables when compared to enabling SQL search engine.
  • Sometimes some characters haven't been identified and compared when comparing data between two environments.
  • It needs better customer support for utilizing the tool, and cost factor also matter.
Anonymous | TrustRadius Reviewer

Support Rating

Oracle Enterprise Manager

No score
No answers yet
No answers on this topic

Redgate SQL Data Compare

Redgate SQL Data Compare 10.0
Based on 2 answers
Redgate is always fast to respond to any tickets I submit and provide fixes for any issues rapidly.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Oracle Enterprise Manager

Toad for Oracle is more suited for individual users who have a strong focus on database development, and it is not as comprehensive as Oracle Enterprise Manager. While it is quite decent in logical database layer tasks, such as schema objects and SQL, it lacks visibility into host level and I/O layer performance stats.
Anonymous | TrustRadius Reviewer

Redgate SQL Data Compare

We have used Symantecs Database Agents for Backup Exec and Veeam's Database Backup products. Symantec does not stack up well as compared to Redgate. Veeam is a considerable contender with their SQL Server Explorer. In some scenarios I would prefer to use VEEAM over Redgate, but Redgate is a very stable product that is extremely useful.
Michael Jipping | TrustRadius Reviewer

Return on Investment

Oracle Enterprise Manager

  • You are practically blind without OEM. There are other tools available but are expensive and negatively impact database performance.
  • If a bug hits OEM and it skips monitoring or doesn't catch something, it can have extremely negative consequences.
  • Being able to deploy scripts through OEM has replaced thousands of hours of work.
Anonymous | TrustRadius Reviewer

Redgate SQL Data Compare

  • An incredible gain in terms of time
  • Speed in compiling the data update scripts
  • Ease in comparing tables
Luca Campanelli | TrustRadius Reviewer

Pricing Details

Oracle Enterprise Manager

General

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

Redgate SQL Data Compare

General

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

Rating Summary

Likelihood to Recommend

Oracle Enterprise Manager
8.8
Redgate SQL Data Compare
9.5

Support Rating

Oracle Enterprise Manager
Redgate SQL Data Compare
10.0

Add comparison