Vendors/3rd-party Products

External Article

Building a Database with Flyway

  • Article

Flyway, especially Flyway Teams edition, can be used in several different ways to accommodate a database development that was originally based on builds rather than migrations. This article explores four different ways to use Flyway to build a particular version of a database, from the ground up, using a single migration script. It should help teams select the best way to incorporate Flyway into an existing database build system, during development, while benefitting from use of Flyway's versioned migration system for deployments and releases.

2022-08-08

External Article

Taming Database Documentation with Flyway and MySQL

  • Article

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.

2022-07-18

External Article

Cross-RDBMS Version Checks in Flyway

  • Article

How does one check that a database is definitively at the version that Flyway says it is? Or that a test teardown procedure leaves no trace in the database? Or verify that an undo script returns a database's metadata to that state it should be in for the version to which you're rolling back? This article shows how to do high-level version checks, by comparing JSON models.

2022-07-13

Blogs

Working with Neo4j Imports–I HATE CASE SENSITIVITY

By

I’ve been working to better understand graph databases and where they can be useful....

Daily Coping 8 Aug 2022

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Azure DevOps: Deploying Power BI reports with a parameterized gateway-based Data Source

By

(2022-Aug-08) You have developed your Power BI report, by connecting one or more sourcing datasets,...

Read the latest Blogs

Forums

Retrieve records added across database (all user table) after a specific date

By fafful

I would like a query to retrieve all records that have been added after...

sql server Invalid Views(including ambiguous columns)

By RazLinky

Hi, I need to check for invalid views in my DB (including ambiguous columns)...

WSFC DNS issue.

By snomadj

Morning all! I need to change the DNS entry for the IP address for...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

DATETRUNC

See possible answers