Vendors/3rd-party Products

External Article

Using SQL Backup in Development Work

  • Article

For a development team, SQL Backup provides a simple way to restore development or test databases, if required, while minimizing the tedium of the task of taking, managing, and restoring the backups. We can generate the required backup commands in the GUI and then use them to construct a SQL script that backs up all the required databases. We can even use the backup commands in a beforeMigrate SQL callback, in Flyway, to make sure the current version is safely backed up before we run migration.

2022-11-23

External Article

Finding the Version of a Flyway-managed Database Using SQL

  • Article

Maintaining a version of a database opens a lot of possibilities, especially if an automated process can easily grab the current version, at runtime, using just SQL. 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. No more desultory quests, when dealing with support issues, or when bug fixing, to find which database version was running when the bug happened.

2022-10-14

External Article

Rollbacks, Undos and Undonts

  • Article

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

Blogs

Speaking at SQLSaturday MN 2022

By

Thanks all for joining me for two sessions at SQLSaturday Minnesota 2023, and for...

Goal Progress for Nov 2022

By

I set goals at the beginning of the year, and I’m tracking my progress...

PGSQL PHRIDAY #3: What is the PostgreSQL Community To You?

By

Very excited to take part in my third #PGSQLPhriday blogging event, even more so...

Read the latest Blogs

Forums

Help Parsing String

By Tav29

I can do the Last Name, First Name; my problem is Middle Initial. I...

SSRS REPORT

By RDOT

Hi Guys have project the require to create checkbox in one off my ssrs...

Selecting temp tables & CTEs using PowerBI

By JeremyU

I have a pretty difficult assignment. This is the structure that I need to...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers