TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    dbt

    Score9.2 out of 10
    N/Adbt is an SQL development environment, developed by Fishtown Analytics, now known as dbt Labs. The vendor states that with dbt, analysts take ownership of the entire analytics engineering workflow, from writing data transformation code to deployment and documentation. dbt Core is distributed under the Apache 2.0 license, and paid Teams and Enterprise editions are available.

    $0

    per month per seat

    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

    Pricing
    dbtRedgate Flyway
    Editions & Modules
    No answers on this topic
    Community
    Free
    Enterprise
    Contact Sales
    Offerings
    Pricing Offerings
    dbtRedgate Flyway
    Free Trial
    YesYes
    Free/Freemium Version
    YesYes
    Premium Consulting/Integration Services
    YesYes
    Entry-level Setup FeeNo setup feeOptional
    Additional Details——
    More Pricing Information
    Features
    dbtRedgate Flyway
    Data Transformations
    Comparison of Data Transformations features of dbt and Redgate Flyway
    Feature
    dbt
    9.8
    8 Ratings
    19% above category average
    Redgate Flyway
    -
    Ratings
    Simple transformations10.08 Ratings00 Ratings
    Complex transformations9.58 Ratings00 Ratings
    Data Modeling
    Comparison of Data Modeling features of dbt and Redgate Flyway
    Feature
    dbt
    9.1
    8 Ratings
    14% above category average
    Redgate Flyway
    -
    Ratings
    Data model creation9.88 Ratings00 Ratings
    Metadata management8.88 Ratings00 Ratings
    Business rules and workflow9.08 Ratings00 Ratings
    Collaboration10.06 Ratings00 Ratings
    Testing and debugging8.08 Ratings00 Ratings
    Best Alternatives
    dbtRedgate Flyway
    Small Businesses
    Skyvia
    Score10 out of 10
    No answers on this topic
    Medium-sized Companies
    IBM InfoSphere Information Server
    Score10 out of 10
    Toad Database Developer Tools
    Score9.2 out of 10
    Enterprises
    SolarWinds Task Factory
    Score8.3 out of 10
    Toad Database Developer Tools
    Score9.2 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    dbtRedgate Flyway
    Likelihood to Recommend
    10.0
    (10 ratings)
    9.0
    (7 ratings)
    Usability
    9.8
    (3 ratings)
    9.1
    (3 ratings)
    User Testimonials
    dbtRedgate Flyway
    Likelihood to Recommend
    dbt Labs
    The prerequisite is that you have a supported database/data warehouse and have already found a way to ingest your raw data. Then dbt is very well suited to manage your transformation logic if the people using it are familiar with SQL. If you want to benefit from bringing engineering practices to data, dbt is a great fit. It can bring CI/CD practices, version control, automated testing, documentation generation, etc. It is not so well suited if the people managing the transformation logic do not like to code (in SQL) but prefer graphical user interfaces.
    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
    Pros
    dbt Labs
    • dbt supports version control through GIT, this allows teams to collaborate and track the data transformation logic.
    • dbt allows us to build data models which helps to break complex transformation logic into simple and smaller logic.
    • dbt is completely based on SQL which allows data analyst and data engineers to build the transformation logic.
    • dbt can be easily integrated with snowflake.
    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
    Cons
    dbt Labs
    • Field-level lineage (currently at table level)
    • Documentation inheritance - if a field is documented the downstream field of the same name could inherit the doc info
    • Adding python model support (in beta now)
    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
    Usability
    dbt Labs
    dbt is very easy to use. Basically if you can write SQL, you will be able to use dbt to get what you need done. Of course more advanced users with more technical skills can do more things.
    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
    Alternatives Considered
    dbt Labs
    I actually don't know what the alternative to dbt is. I'm sure one must exist other than more 'roll your own' options like Apache Airflow, say, bu tin terms of super easy managed/cloud data transforms, dbt really does seem to be THE tool to use. It's $50/month per dev, BUT there's a FREE version for 1 dev seat with no read-only access for anyone else, so you can always start with that and then buy yourself a seat later.
    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
    Return on Investment
    dbt Labs
    • Simplified our BI layer for faster load times
    • Increased the quality of data reaching our end users
    • Makes complex transformations manageable
    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
    ScreenShots

    Redgate Flyway Screenshots

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