Tag Archives: Redgate

Creating a Flyway Desktop Shadow Database in PostgreSQL

Posted on February 6, 2023 by way0utwest

In order to generate migrations, we need to configure Flyway to use a shadow database. This post looks at that process. This is part of a series of working through Flyway and Flyway desktop to demo database changes. Disclosure: I … Continue reading →

Posted in Blog | Tagged , , , , | 4 Comments

Flyway Desktop Projects for My PoC

Posted on January 30, 2023 by way0utwest

In a previous post, I set up the basic databases for the PoC project I’m working on. In this next post, we’ll get the Flyway Desktop projects set up for the PoC. This is part of a series of working … Continue reading →

Posted in Blog | Tagged , , , , | 3 Comments

Using SQL Data Compare from the Command Line with a Project

Posted on January 25, 2023 by way0utwest

SQL Data Compare (SDC) is a great way to sync data among tables. It’s a software utility analogous to SQL Compare, but working with data rather than schema. I had a customer ask recently about setting up a SDC project … Continue reading →

Posted in Blog | Tagged , , | Comments Off on Using SQL Data Compare from the Command Line with a Project

No Flyway Baseline No Migration

Posted on January 16, 2023 by way0utwest

In my experiments with the Flyway CLI (fwcli), I’m finding some interesting behavior, some of which is catching my by surprise. This post looks at the baseline command and the issues with not having one. I also cover a naming … Continue reading →

Posted in Blog | Tagged , , | 1 Comment