3 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.2 out of 100
38 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 9.4 out of 100

Likelihood to Recommend

Oracle Autonomous Transaction Processing

As with any cloud service, the main advantage of Oracle Autonomous Transaction Processing is the ability to scale up (and down, if required), thus reducing initial costs. You can start with a simple 1 CPU and 20Gb instance for free, and scale up to meet your requirements with some simple clicks. You do not have to worry about administrative tasks (OS installation and configuration, storage provisioning, software installation/upgrade, maintenance, etc.).
Lisandro Fernigrini | TrustRadius Reviewer

Redgate SQL Compare

We use SQL Compare to troubleshoot performance problems quite a bit since our data model is more like a template and not everything is 100% in sync and customization occurs between different client databases. We continually get pulled into performance issues and the developers will say Client A is performing different than Client B, why? Using SQL Compare, we usually find that one client was tuned and had indexes altered or added that weren't deployed to all clients or other objects weren't deployed correctly during the release.On the other hand, since our data model practices allow client databases to drift I tried to create a new golden image by trying to compare multiple databases based on the same data model and found it to be a very difficult process to complete using SQL Compare. SQL Compare gave me too much information and doesn't allow enough filtering to eliminate a lot of the noise.
Kevin R. Zakoski | TrustRadius Reviewer

Feature Rating Comparison

Database Development

Oracle Autonomous Transaction Processing
Redgate SQL Compare
8.9
Version control tools
Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.9
Performance optimization tools
Oracle Autonomous Transaction Processing
Redgate SQL Compare
7.1
Schema maintenance
Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.2
Database change management
Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.2

Database Administration

Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.1
User management
Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.1
Database security
Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.1
Change management
Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.1

Pros

Oracle Autonomous Transaction Processing

  • Quick and simple to deploy (less than 5 steps to create a new instance)
  • No administrative tasks (backup, re-sizing) required
Lisandro Fernigrini | TrustRadius Reviewer

Redgate SQL Compare

  • Extremely fast!
  • Compares from source control, not just physical databases. No need to keep copies of databases of varying versions laying around.
  • Command line tools integrate easily into automated build processes.
  • Even has plugins for products like Octopus Deploy!
Aaron Smith | TrustRadius Reviewer

Cons

Oracle Autonomous Transaction Processing

  • None significant to be mentioned
Lisandro Fernigrini | TrustRadius Reviewer

Redgate SQL Compare

  • So far so good. I have to be honest, it's not a complicated application, and so far hasn't caused me any issues or to question the choices of the developers!
Anonymous | TrustRadius Reviewer

Usability

Oracle Autonomous Transaction Processing

Oracle Autonomous Transaction Processing 7.3
Based on 1 answer
You get almost all the features of Oracle Database, including the ability to deploy APEX applications, without having to worry about system, storage or database configuration and maintenance, backups, etc. Also, you can start for free and move up adding resources as you need.
Lisandro Fernigrini | TrustRadius Reviewer

Redgate SQL Compare

Redgate SQL Compare 7.0
Based on 1 answer
It's a good tool to have, but becomes expensive to buy a user license for each developer.
Anonymous | TrustRadius Reviewer

Support Rating

Oracle Autonomous Transaction Processing

No score
No answers yet
No answers on this topic

Redgate SQL Compare

Redgate SQL Compare 9.2
Based on 4 answers
They have a great community website where you can search for answers but are also very responsive when it comes to direct support.
Anonymous | TrustRadius Reviewer

Alternatives Considered

Oracle Autonomous Transaction Processing

Both Azure SQL Database and Oracle Autonomous Transaction Processing offer a powerful and robust database platform. The advantage of Autonomous Transaction Processing is the ability to host APEX applications for free and without any special/complicated deployment or configuration process. Having a rapid development environment embedded for free was the main advantage for choosing Oracle as my cloud database provider.
Lisandro Fernigrini | TrustRadius Reviewer

Redgate SQL Compare

Honestly, I have never been interested in the usable alternatives. I have always been good to use it. The license cost after all has always been sustainable. I never had the idea of \ u200b \ u200bchanging it nor the need to look at other software. Also (always a redgate software) I use the Data Compare which is the "twin brother" for data check.
Luca Campanelli | TrustRadius Reviewer

Return on Investment

Oracle Autonomous Transaction Processing

  • Using the free tier allows me to develop and test the APEX app with no cost.
  • Changing it from a single-user to a department tool is simple.
Lisandro Fernigrini | TrustRadius Reviewer

Redgate SQL Compare

  • It's reduced errors and bugs associated with deploying new application features and forgetting to apply required database changes (or incorrectly applying them).
  • It's made deploying new features a quicker task, eliminating the often laborious task of synchronizing schemas and data across databases.
  • These sometimes complex queries and operations can easily be performed by any developer and don't require the involvement of a database administrator to perform.
Richard Davies | TrustRadius Reviewer

Screenshots

Pricing Details

Oracle Autonomous Transaction Processing

General

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

Redgate SQL Compare

General

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

Rating Summary

Likelihood to Recommend

Oracle Autonomous Transaction Processing
8.2
Redgate SQL Compare
9.3

Usability

Oracle Autonomous Transaction Processing
7.3
Redgate SQL Compare
7.0

Support Rating

Oracle Autonomous Transaction Processing
Redgate SQL Compare
9.2

Add comparison