You may also like

• 

  Article

  Simple Safeguards for PowerShell Scripting with Flyway

  This article demonstrates simple techniques to security-check any processes that use Bash or PowerShell scripts to automate database tasks, when using Flyway. These checks help ensure a script is trusted, hasn't been tampered with since creation, and doesn't contain commands commonly used with malicious intent. They add a valuable layer of protection, without sacrificing the power and flexibility that makes Flyway so effective.

• 

  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.

• 

  Webinar

  Level Up with Flyway - Online Training Hub

  Throughout this course, you will explore a broad spectrum of modules focusing on the full Flyway solution, from Development through to Deployment and Test Data Management. Designed as a three-session course, make sure to register at each of the links below to ensure you’re in the know for all three. Module 1: Database Development with

• 

  Article

  Taming Database Documentation with Flyway and MySQL

  Database object documentation is essential for explaining to busy developers, and the wider business, the purpose of each object and how to use it. The solution presented in this article consists of a SQL script to allow developers to add comments to MySQL database objects, without affecting the database version, and a simple way to generate a documentation report, in JSON. The SQL script will execute automatically as a callback, during any Flyway Teams migration run, and the report will allow the team to spot any gaps quickly.

• 

  Article

  Managing Static Data in Flyway Database Development

  If your database application requires 'static data' to function, then the best way to manage that data is using a view based on a derived table. This article demonstrates ways to create these views, depending on your RDBMS's capabilities, and how to build and manage them in development work, using Flyway and PowerShell.

• 

  Article

  Getting an Overview of Changes to a PostgreSQL Database using Flyway

  How to use Flyway and PowerShell to automatically generate a database build script every time Flyway successfully created a new version. You can then investigate schema changes between versions simply by using a Diff tool to compare build scripts.