Additional Articles


External Article

Rollbacks, Undos and Undonts

Rollback scripts are designed to allow us to recover safely from a failed deployment that leaves the database in an indeterminate state. They must check exactly what needs to be reverted before doing so. If you work with an RDBMS that cannot support transaction DDL rollback they are vital. This article proposes a strategy where you create and test a rollback file, at the same time as the forward migration, and reuse it as a Flyway undo script.

2022-09-09

External Article

Managing Datasets for Database Development Work using Flyway

A generic way of exporting, deleting and loading data, for database development work. It uses Flyway Teams, a PowerShell framework, JSON files for storage and a table manifest to define the correct order of dependency for each task. It should help a team maintain datasets between database versions, as well as to switch between the datasets required to support different types of testing.

2022-09-05

Blogs

Tales From The Field Weekly Wrap Up

By

 Hello Dear Reader! It's been a while.  I've been busy working with a few colleagues...

PGSQL Phriday #001: Two Truths and a Lie

By

As a part of my own journey of learning within PostgreSQL, I’ve decided that...

Daily Coping 7 Oct 2022

By

Today’s coping tip is to be willing to share how you feel and ask...

Read the latest Blogs

Forums

MDP/CTP values

By ramana3327

Hi All, We have a server with 8 cpus. Some times Thread count is...

Any reason to use AWS WAF over Cloudflare?

By obalikawa

I'm primarily using Cloudflare for security. I was wondering if AWS WAF is any...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers