Alternatives to Sqitch logo

Alternatives to Sqitch

Flyway, Liquibase, Slick, Spring Data, and Microsoft SQL Server Management Studio are the most popular alternatives and competitors to Sqitch.
7
59
+ 1
1

What is Sqitch and what are its top alternatives?

It is a standalone change management system with no opinions about your database engine, application framework, or development environment. Native scripting. Changes are implemented as scripts native to your selected database engine.
Sqitch is a tool in the Database Tools category of a tech stack.

Top Alternatives to Sqitch

  • Flyway

    Flyway

    It lets you regain control of your database migrations with pleasure and plain sql. Solves only one problem and solves it well. It migrates your database, so you don't have to worry about it anymore. ...

  • Liquibase

    Liquibase

    Liquibase is a leading open-source tool for database schema change management. Liquibase helps teams track, version, and deploy database schema and logic changes so they can automate their database code process with their app code process. ...

  • Slick

    Slick

    It is a modern database query and access library for Scala. It allows you to work with stored data almost as if you were using Scala collections while at the same time giving you full control over when a database access happens and which data is transferred. ...

  • Spring Data

    Spring Data

    It makes it easy to use data access technologies, relational and non-relational databases, map-reduce frameworks, and cloud-based data services. This is an umbrella project which contains many subprojects that are specific to a given database. ...

  • Microsoft SQL Server Management Studio

    Microsoft SQL Server Management Studio

    It is an integrated environment for managing any SQL infrastructure, from SQL Server to Azure SQL Database. It provides tools to configure, monitor, and administer instances of SQL Server and databases. Use it to deploy, monitor, and upgrade the data-tier components used by your applications, as well as build queries and scripts. ...

  • DataGrip

    DataGrip

    A cross-platform IDE that is aimed at DBAs and developers working with SQL databases. ...

  • Sequel Pro

    Sequel Pro

    Sequel Pro is a fast, easy-to-use Mac database management application for working with MySQL databases. ...

  • PostGIS

    PostGIS

    PostGIS is a spatial database extender for PostgreSQL object-relational database. It adds support for geographic objects allowing location queries to be run in SQL. ...

Sqitch alternatives & related posts

Flyway logo

Flyway

206
394
29
Version control for your database
206
394
+ 1
29
PROS OF FLYWAY
  • 11
    Superb tool, easy to configure and use
  • 9
    Very easy to config, great support on plain sql scripts
  • 5
    Is fantastic and easy to install even with complex DB
  • 4
    Simple and intuitive
CONS OF FLYWAY
  • 2
    "Undo Migrations" requires pro version, very expensive

related Flyway posts

Miguel Suarez

Flyway vs Liquibase #Migration #Backwards-compatible

We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

See more
Shared insights
on
Flyway
Liquibase

All the DB deployments in our current organization are manual. We want to automate them. We are leaning toward Liquibase since it has versioning and rollbacks. Is Flyway better or Liquibase?

See more
Liquibase logo

Liquibase

228
432
44
Source control for your database
228
432
+ 1
44
PROS OF LIQUIBASE
  • 16
    Great database tool
  • 13
    Many DBs supported
  • 7
    Easy setup
  • 5
    Database independent migration scripts
  • 2
    Unique open source tool
  • 1
    Database version controller
CONS OF LIQUIBASE
  • 3
    Documentation is disorganized
  • 2
    No vendor specifics in XML format - needs workarounds

related Liquibase posts

Miguel Suarez

Flyway vs Liquibase #Migration #Backwards-compatible

We were looking for a tool to help us integrating the migration scripts as part of our Deployment. At first sight both tools look very alike, are well integrated with Spring, have a fairly frequent development activity and short release cycles.

Liquibase puts a lot of emphasis on independence with the DB, allowing you to create the scripts on formats like JSON and YML, abstracting away from SQL, which it's also supported. Since we only work with one DB type across services we wouldn't take much advantage of this feature.

Flyway on the other hand has the advantage on being actively working on the integration with PostgreSQL 11, for it's upcoming version 6. Provides a more extensive set of properties that allow us to define what's allowed on what's not on each different environment.

Instead of looking for a tool that will allow us to rollback our DB changes automatically, we decided to implement backwards-compatible DB changes, for example adding a new column instead of renaming an existing one, postponing the deletion of the deprecated column until the release has been successfully installed.

See more
Shared insights
on
Flyway
Liquibase

All the DB deployments in our current organization are manual. We want to automate them. We are leaning toward Liquibase since it has versioning and rollbacks. Is Flyway better or Liquibase?

See more
Slick logo

Slick

8.5K
539
0
Database query and access library for Scala
8.5K
539
+ 1
0
PROS OF SLICK
    Be the first to leave a pro
    CONS OF SLICK
      Be the first to leave a con

      related Slick posts

      Spring Data logo

      Spring Data

      355
      277
      0
      Provides a consistent approach to data access – relational, non-relational, map-reduce, and beyond
      355
      277
      + 1
      0
      PROS OF SPRING DATA
        Be the first to leave a pro
        CONS OF SPRING DATA
          Be the first to leave a con

          related Spring Data posts

          Остап Комплікевич

          I need some advice to choose an engine for generation web pages from the Spring Boot app. Which technology is the best solution today? 1) JSP + JSTL 2) Apache FreeMarker 3) Thymeleaf Or you can suggest even other perspective tools. I am using Spring Boot, Spring Web, Spring Data, Spring Security, PostgreSQL, Apache Tomcat in my project. I have already tried to generate pages using jsp, jstl, and it went well. However, I had huge problems via carrying already created static pages, to jsp format, because of syntax. Thanks.

          See more
          Microsoft SQL Server Management Studio logo

          Microsoft SQL Server Management Studio

          323
          238
          0
          An integrated environment for managing any SQL infrastructure
          323
          238
          + 1
          0
          PROS OF MICROSOFT SQL SERVER MANAGEMENT STUDIO
            Be the first to leave a pro
            CONS OF MICROSOFT SQL SERVER MANAGEMENT STUDIO
              Be the first to leave a con

              related Microsoft SQL Server Management Studio posts

              Kelsey Doolittle

              We have a 138 row, 1700 column database likely to grow at least a row and a column every week. We are mostly concerned with how user-friendly the graphical management tools are. I understand MySQL has MySQL WorkBench, and Microsoft SQL Server has Microsoft SQL Server Management Studio. We have about 6 months to migrate our Excel database to one of these DBMS, and continue (hopefully manually) importing excel files from then on. Any tips appreciated!

              See more
              DataGrip logo

              DataGrip

              299
              324
              14
              A database IDE for professional SQL developers
              299
              324
              + 1
              14
              PROS OF DATAGRIP
              • 4
                Works on Linux, Windows and MacOS
              • 2
                Wide range of DBMS support
              • 1
                Code completion
              • 1
                Generate ERD
              • 1
                Quick-fixes using keyboard shortcuts
              • 1
                Code analysis
              • 1
                Database introspection on 21 different dbms
              • 1
                Export data using a variety of formats using open api
              • 1
                Import data
              • 1
                Diff viewer
              CONS OF DATAGRIP
                Be the first to leave a con

                related DataGrip posts

                Sequel Pro logo

                Sequel Pro

                285
                267
                66
                MySQL database management for Mac OS X
                285
                267
                + 1
                66
                PROS OF SEQUEL PRO
                • 23
                  Free
                • 18
                  Simple
                • 17
                  Clean UI
                • 8
                  Easy
                CONS OF SEQUEL PRO
                  Be the first to leave a con

                  related Sequel Pro posts

                  PostGIS logo

                  PostGIS

                  277
                  275
                  29
                  Open source spatial database
                  277
                  275
                  + 1
                  29
                  PROS OF POSTGIS
                  • 24
                    De facto GIS in SQL
                  • 5
                    Good Documentation
                  CONS OF POSTGIS
                    Be the first to leave a con

                    related PostGIS posts