TrustRadius: an HG Insights company

Redgate Flyway vs. SQL Server Management Studio (SSMS)

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Redgate Flyway

    Score9.6 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

    SQL Server Management Studio (SSMS)

    Score8.1 out of 10
    N/ASQL Server Management Studio (SSMS) is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. SSMS provides tools to configure, monitor, and administer instances of SQL Server and databases. SSMS is used to deploy, monitor, and upgrade the data-tier components used by applications, and to build queries and scripts. SSMS can also be used to query, design, and manage databases and data warehouses on a local…

    $0

    Pricing
    Redgate FlywaySQL Server Management Studio (SSMS)
    Editions & Modules
    Community
    Free
    Enterprise
    Contact Sales
    No answers on this topic
    Offerings
    Pricing Offerings
    Redgate FlywaySQL Server Management Studio (SSMS)
    Free Trial
    YesNo
    Free/Freemium Version
    YesYes
    Premium Consulting/Integration Services
    YesNo
    Entry-level Setup FeeOptionalNo setup fee
    Additional Details——
    More Pricing Information
    Best Alternatives
    Redgate FlywaySQL Server Management Studio (SSMS)
    Small Businesses
    No answers on this topic
    Visual Studio
    Score9.1 out of 10
    Medium-sized Companies
    Redgate SQL Toolbelt Essentials
    Score8.2 out of 10
    PyCharm
    Score9.3 out of 10
    Enterprises
    Redgate SQL Toolbelt Essentials
    Score8.2 out of 10
    WebStorm
    Score9.6 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Redgate FlywaySQL Server Management Studio (SSMS)
    Likelihood to Recommend
    8.0
    (4 ratings)
    7.0
    (1 ratings)
    User Testimonials
    Redgate FlywaySQL Server Management Studio (SSMS)
    Likelihood to Recommend
    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
    Microsoft
    Very well easy to use and helps productivity of user drastically
    Incentivized
    Read full review
    Pros
    Redgate
    • Supports many databases
    • Community version uses Apache license
    • Widely used, good community support
    Incentivized
    Read full review
    Microsoft
    • Export data
    • Generate scripts
    • connecting to SQL instances
    Incentivized
    Read full review
    Cons
    Redgate
    • GUI could be more user friendly
    • Applying patch scripts on a blank DB differs from on a DB with data, so the migration could still fail when all tests passed
    • Configurations options could be more flexible / powerful
    Incentivized
    Read full review
    Microsoft
    • it can still be made easier for connecting perspective
    • some bugs on versions of SQL can be avoided.
    • can be more user friendly
    Incentivized
    Read full review
    Alternatives Considered
    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
    Microsoft
    SSMS is very efficient and aids to do multiple tabs easily
    Incentivized
    Read full review
    Return on Investment
    Redgate
    • Reduced our effort for release processes.
    • Easy to setup - less than 5 minutes.
    • Improve reliability of our databases.
    • Easy backup and version control.
    Incentivized
    Read full review
    Microsoft
    • easy to use accessibility
    • durability, It has been durable
    • recovery of old tabs.
    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