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

SAP Replication Server

I asked questions about a warm standby and multicast replication. We ended up using bi-directional replication and a warm standby db. Having 3 or more live OLTP DB's where each was read-write was going to be difficult to manage for contention if the same table was being updated. We stuck with an easier solution to have only two OLTP's, and then used additional DB's as read-only DW's.
Bruce Speidel | TrustRadius Reviewer

Feature Rating Comparison

Database Development

dbForge Data Compare for MySQL
8.0
SAP Replication Server
Database change management
dbForge Data Compare for MySQL
8.0
SAP Replication Server

Data Source Connection

dbForge Data Compare for MySQL
SAP Replication Server
9.8
Connect to traditional data sources
dbForge Data Compare for MySQL
SAP Replication Server
9.6
Connecto to Big Data and NoSQL
dbForge Data Compare for MySQL
SAP Replication Server
10.0

Data Transformations

dbForge Data Compare for MySQL
SAP Replication Server
9.7
Simple transformations
dbForge Data Compare for MySQL
SAP Replication Server
9.8
Complex transformations
dbForge Data Compare for MySQL
SAP Replication Server
9.6

Data Modeling

dbForge Data Compare for MySQL
SAP Replication Server
8.2
Data model creation
dbForge Data Compare for MySQL
SAP Replication Server
8.3
Metadata management
dbForge Data Compare for MySQL
SAP Replication Server
8.3
Business rules and workflow
dbForge Data Compare for MySQL
SAP Replication Server
7.6
Collaboration
dbForge Data Compare for MySQL
SAP Replication Server
8.3
Testing and debugging
dbForge Data Compare for MySQL
SAP Replication Server
8.4

Data Governance

dbForge Data Compare for MySQL
SAP Replication Server
8.3
Integration with data quality tools
dbForge Data Compare for MySQL
SAP Replication Server
9.6
Integration with MDM tools
dbForge Data Compare for MySQL
SAP Replication Server
6.9

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

SAP Replication Server

  • guaranteed delivery
  • high availability
  • scalable
  • low latency
  • data transformation
Gene Baker | 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

SAP Replication Server

  • So far we have not dealt with any challenges since we started to utilise its functionality or high speed data replication, with integrated transnational data from different data sources to exchange the replication of data.
  • Our only small concern is it takes extra effort to maintain the hardware and you need special DBAs skills to properly utilise its functionality with its capacity .
Pradeep Bele | TrustRadius Reviewer

Support Rating

dbForge Data Compare for MySQL

No score
No answers yet
No answers on this topic

SAP Replication Server

SAP Replication Server 10.0
Based on 1 answer
SAP support has been outstanding. They have quick response times and always meet their SLAs. Any time we have an issue that needs to be researched they are able to get back to us quickly with resolution.
Gene Baker | 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

SAP Replication Server

Hands down Sybase has the best replication
Bruce Speidel | 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

SAP Replication Server

  • A positive is that it allow quick business decision making on the basis of real time data. Huge time saving for business.
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

SAP Replication Server

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
SAP Replication Server
9.6

Support Rating

dbForge Data Compare for MySQL
SAP Replication Server
10.0

Add comparison