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

We use Schema Compare for two main scenarios:
1) Creating schema upgrade scripts to use when deploying. As our schema grows and changes, we want to tie these changes to a specific build so related code changes will be deployed along with side database schema changes. We do this by using Schema Compare to compare the modified dev database to a stable staging environment database, and then save a sync script. We can then modify that script as needed (perhaps with some update statements for migration), and include that in the deploy artifacts, which our deployment will automatically run.
2) Syncing the developer database with changes from other developers, matching prod schema, or otherwise managing dev database instances.
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 Schema Compare for MySQL
9.1
SAP Replication Server
Schema maintenance
dbForge Schema Compare for MySQL
9.1
SAP Replication Server
Database change management
dbForge Schema Compare for MySQL
9.1
SAP Replication Server

Data Source Connection

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

Data Transformations

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

Data Modeling

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

Data Governance

dbForge Schema Compare for MySQL
SAP Replication Server
8.3
Integration with data quality tools
dbForge Schema Compare for MySQL
SAP Replication Server
9.7
Integration with MDM tools
dbForge Schema Compare for MySQL
SAP Replication Server
6.9

Pros

dbForge Schema Compare for MySQL

  • Compare entire or subset of MySQL tables between databases.
  • Configure comparison rules.
  • Automatically sync schemas between databases on a per-table basis.
  • Save comparison rules for reuse and sharing.
  • 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 Schema Compare for MySQL

  • When viewing a table comparison, data is presented in a text-based format (such as a diff viewer). This is inferior to a more structured view like dbForge Data Compare has.
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 Schema 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 Schema 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 export the entire schema to a text file and use diff tools to compare differences.
Anthony Aziz | TrustRadius Reviewer

SAP Replication Server

Hands down Sybase has the best replication
Bruce Speidel | TrustRadius Reviewer

Return on Investment

dbForge Schema Compare for MySQL

  • Improve developer productivity by making schema syncing quicker and easier.
  • Reduce risk of deployment by ensuring schema changes will be applied appropriately.
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 Schema 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 Schema Compare for MySQL
9.1
SAP Replication Server
9.7

Support Rating

dbForge Schema Compare for MySQL
SAP Replication Server
10.0

Add comparison