TrustRadius: an HG Insights company

Red Hat Ansible Automation Platform vs. Redgate Flyway vs. Redgate SQL Toolbelt Essentials

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Ansible

    Score9 out of 10
    N/AThe Red Hat Ansible Automation Platform (acquired by Red Hat in 2015) is a foundation for building and operating automation across an organization. The platform includes tools needed to implement enterprise-wide automation, and can automate resource provisioning, and IT environments and configuration of systems and devices. It can be used in a CI/CD process to provision the target environment and to then deploy the application on it.

    $5,000

    per year

    Redgate Flyway

    Score9 out of 10
    N/ARedgate Flyway extends DevOps practices to databases to speed up software delivery while keeping business-critical data safe. From version control to continuous delivery, Redgate Flyway helps enterprises build on application delivery processes to automate database development and deployments.

    $0

    Redgate SQL Toolbelt Essentials

    Score9.6 out of 10
    N/ARedgate's SQL Toolbelt Essentials includes industry-standard tools for SQL Server development & deployment, enabling users to include SQL Server databases in agile processes and enabilng developers to embed robust and scalable development practices.

    $1,209

    per year per user (1-4 users)

    Pricing
    AnsibleRedgate FlywayRedgate SQL Toolbelt Essentials
    Editions & Modules
    Basic Tower
    5,000
    per year
    Enterprise Tower
    10,000
    per year
    Premium Tower
    14,000
    per year
    Community
    Free
    Enterprise
    Contact Sales
    No answers on this topic
    Offerings
    Pricing Offerings
    AnsibleRedgate FlywayRedgate SQL Toolbelt Essentials
    Free Trial
    NoYesYes
    Free/Freemium Version
    NoYesNo
    Premium Consulting/Integration Services
    NoYesNo
    Entry-level Setup FeeNo setup feeOptionalNo setup fee
    Additional Details———
    More Pricing Information
    Best Alternatives
    AnsibleRedgate FlywayRedgate SQL Toolbelt Essentials
    Small Businesses
    Salt
    Score6.2 out of 10
    No answers on this topic
    No answers on this topic
    Medium-sized Companies
    Perforce Puppet
    Score8.5 out of 10
    Toad Database Developer Tools
    Score9.2 out of 10
    No answers on this topic
    Enterprises
    Salt
    Score6.2 out of 10
    Toad Database Developer Tools
    Score9.2 out of 10
    Oracle SQL Developer
    Score8.1 out of 10
    All AlternativesView all alternativesView all alternativesView all alternatives
    User Ratings
    AnsibleRedgate FlywayRedgate SQL Toolbelt Essentials
    Likelihood to Recommend
    8.8
    (292 ratings)
    9.0
    (7 ratings)
    8.0
    (14 ratings)
    Likelihood to Renew
    9.2
    (8 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Usability
    8.3
    (184 ratings)
    9.1
    (3 ratings)
    7.0
    (1 ratings)
    Performance
    8.7
    (5 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Support Rating
    8.0
    (5 ratings)
    -
    (0 ratings)
    8.6
    (5 ratings)
    Implementation Rating
    8.0
    (2 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    Ease of integration
    8.6
    (5 ratings)
    -
    (0 ratings)
    -
    (0 ratings)
    User Testimonials
    AnsibleRedgate FlywayRedgate SQL Toolbelt Essentials
    Likelihood to Recommend
    Red Hat
    I think it's the best defacto orchestrator for automation because it's so easy to integrate in other tools to it (dynatrace, cyberark, terraform, etc). It is a lot for a new or smaller team to use so I wouldn't recommend it to a new team using Ansible, in that case using Ansible navigator is a better start to understanding playbooks/inventories before diving into the complexity of Red Hat Ansible Automation Platform. EDA also takes a lot of connectivity between Red Hat Ansible Automation Platform and target systems to get working which can be difficult in very locked down envs unless you have approval from many other teams like networking and security.
    Incentivized
    Read full review
    Redgate
    Database Migrations on Java-based solutions. It has one of the best integrations with it as a database migration tool, you can do it with the community edition (no pricing involved) and it works flawlessly with Maven and Gradle. It's not an expensive tool in order to use the next level of features and is worth the money. I would recommend reaching that edition level as the object mapping feature gets really handy. I would not recommend it for any Microsoft-based solution (.Net) as is not compatible at all based on my experience, this is a tool only worth it with Java applications.
    Incentivized
    Read full review
    Redgate
    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.
    Incentivized
    Read full review
    Pros
    Red Hat
    • Standardize controls and visibility for automation.
    • Provide RBAC and Vault for improved automation security and support.
    • Job Scheduling is much more effective than Cron or other home-grown solutions.
    • The Red Hat Ansible Automation Platform API is one of the best features as it makes automation accessible from any other platform.
    Incentivized
    Read full review
    Redgate
    • Manage DB migration patch scripts
    • Apply DB migration patch scripts
    • Test DB migration patch scripts
    • Setup new DB instances, including on local env
    Incentivized
    Read full review
    Redgate
    • Simple and easy comparison of database schemas and 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.
    Incentivized
    Read full review
    Cons
    Red Hat
    • Ansible is still not truly declarative like Terraform.
    • Simple automation is fine, but creating complex, scalable automation scripts is very difficult to learn.
    • For a higher number of nodes, Ansible consumes a lot of resources. It needs the paid version of AAP, which requires a cost.
    Incentivized
    Read full review
    Redgate
    • Updating it causes problems, there have been unnecessary changes that wasted time
    • Requires knowledge & studying so it's used properly
    • Lots of options that might be difficult to understand for non technical people
    Incentivized
    Read full review
    Redgate
    • Pricing.... I wish there was an inexpensive developer version I could buy for myself.
    • Portability.... I would like to use it from a flash drive so I can use it where ever I am asked to work.
    • Unbundled.... This may be available already but I dont' recall I can buy it cheaply as a stand-alone product. Its only part of the bundle - cost effectively.
    Incentivized
    Read full review
    Likelihood to Renew
    Red Hat
    We are extremely happy with the use of AAP. It's better than expected, There is almost no limit when thinking of automation. The only problem is that the day to day is consuming a big part of our time. Patching and checking vulnerabilities are virtually killing us. But we can only improve with AAP.
    Incentivized
    Read full review
    Redgate
    No answers on this topic
    Redgate
    No answers on this topic
    Usability
    Red Hat
    Everything has room for improvement, but Ansible is the best tool out there for what it does and what it can do. There are plenty of features and capabilities that can be added, but it's just a matter of time before it happens.
    Incentivized
    Read full review
    Redgate
    It's very easy to install and use. Even someone very new to the software will have no trouble, plus the team reach out to help you and continue to offer you support throughout. Really simple interface, clean design, all you could really ask for in a tool that needs to do a job dependably
    Incentivized
    Read full review
    Redgate
    It's a good tool to have, but becomes expensive to buy a user license for each developer.
    Incentivized
    Read full review
    Performance
    Red Hat
    Great in almost every way compared to any other configuration management software. The only thing I wish for is python3 support. Other than that, YAML is much improved compared to the Ruby of Chef. The agentless nature is incredibly convenient for managing systems quickly, and if a member of your term has no terminal experience whatsoever they can still use the UI.
    Incentivized
    Read full review
    Redgate
    No answers on this topic
    Redgate
    No answers on this topic
    Support Rating
    Red Hat
    There is a lot of good documentation that Ansible and Red Hat provide which should help get someone started with making Ansible useful. But once you get to more complicated scenarios, you will benefit from learning from others. I have not used Red Hat support for work with Ansible, but many of the online resources are helpful.
    Incentivized
    Read full review
    Redgate
    No answers on this topic
    Redgate
    They have a great community website where you can search for answers but are also very responsive when it comes to direct support.
    Incentivized
    Read full review
    Implementation Rating
    Red Hat
    I spoke on this topic today!
    Incentivized
    Read full review
    Redgate
    No answers on this topic
    Redgate
    No answers on this topic
    Alternatives Considered
    Red Hat
    AAP compares favorably with Terraform and Power Automate. I don't have much experience with Terraform, but I find AAP and Ansible easier to use as well as having more capabilities. Power Platform is also an excellent automation tool that is user friendly but I feel that Ansible has more compatibility with a variety of technologies.
    Incentivized
    Read full review
    Redgate
    The problem with a cloud-based tool for migration services is the cloud dependency. You are restricted to use the tool along the Cloud provider. Flyway gives you the freedom to use it in any scenario as long as you are working with a compatible database engine. Even if you are working on-premise and you don't have plans to move to a cloud architecture. Or even for sandbox development scenarios where you are a developer playing around with some project ideas. And you don't have to pay anything as long as you need advanced features, and not less importantly, you are using an open-source tool.
    Incentivized
    Read full review
    Redgate
    I've used Visual Studio Database Projects for this type of work in the past with some success, but Redgate SQL Compare is faster, more transparent, and simply easier to use. Faster is self explanatory. More transparent, means that it's much easier to set up your desired options for schema change deployment scripts. Easier to use, It's really dead simple. Start a project, connect your source, connect destination, click compare.
    Incentivized
    Read full review
    Return on Investment
    Red Hat
    • First, it keeps our entire server infrastructure aligned with our standards and reduces the time and effort needed to maintain our systems.
    • Automate routine IT tasks to save time, reduce errors, and ensure every server is configured and updated consistently.
    • Tasks that used to take our teams weeks to complete manually now run automatically and reliably, with full visibility, making our infrastructure management more effective and our compliance tracking much easier.
    Incentivized
    Read full review
    Redgate
    • I definitely think it do have positive impact to our company's database management.
    • We have 4 database environments and thus it is easy when we push the database to various environments.
    Read full review
    Redgate
    • Makes deployment fairly simple. Cutting our deployment time down.
    • With the SDK, we can customize our deployment process very quickly and easily.
    • History is not great, it does create scripts you can go back and see but it would be nice to have a quicker version view by object to save time.
    Incentivized
    Read full review
    ScreenShots

    Redgate Flyway Screenshots

    Screenshot of Flyway Enterprise – auto-generation of migration scriptsScreenshot of Flyway Enterprise - reportingScreenshot of Flyway Enterprise - drift detection