You may also like

• 

  Article

  New Redgate Flyway Release - Automate Even More

  Read on to learn about how you can automate even more things with Flyway like project setup and state-based deployments.  We’ll share how you can get the latest version and things you need to know when upgrading. 

• 

  Article

  10 reasons to choose Redgate Flyway

  Thousands of organizations use DevOps practices every day to deliver application changes. But what about the database? Excluding the database from your software delivery lifecycle risks application performance, data security and integrity. With Redgate Flyway Enterprise, you can solve this challenge with one solution built on best-in-class database comparison technology. With capabilities to drive up

• 

  Article

  Installing and Upgrading the Flyway CLI

  This article demonstrates four ways to install and maintain the Flyway CLI. First, running it from Docker. Then, installing it manually on Windows and Linux, with a PowerShell alias to make version switching easier. Third, using a package manager like Chocolatey. Finally, for Windows users, there's a script to automatically download and install the latest Flyway version and make a PowerShell alias that always points to the latest version, even across sessions.

• 

  Article

  Infrequently Asked Questions About Flyway

  You can have Flyway up and running in minutes if you're a solo developer managing a single database. However, as you seek to 'scale up' Flyway to accommodate more complex database systems, team-based development, and stricter quality controls, you'll need to tackle some knottier questions. Without adequate answers, tasks such as multi-database management, automation and workflow, and Continuous Integration will be difficult. Hopefully, this article will help.

• 

  Article

  Find the Version of a Flyway-managed Database

  Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime. You might, for example, have a routine that is only appropriate after a particular version. It is also very handy to be able to associate entries in an event log or bug report with the database version. The article describes various ways to get the current Flyway schema version from Flyway, and how to get it using SQL, in SQL Server, MySQL, PostgreSQL and SQLite.

• 

  Article

  Transferring Database Documentation into SQL DDL Scripts

  We all love having documentation in source code, if not writing it. We just want to ensure that it gets propagated and retained so you and your team members can read it if they need to. This article demonstrates a cross-RDBMS PowerShell task that will extract the comments from a primary JSON source of database documentation and add it to a set of SQL DDL source files.