Overview

Current challenges with (old) Prisma Migrate

Prisma migrate is a declarative schema migrations tool based on the PSL (Prisma Schema Language).

The tool will generate schema migrations by comparing the database schema as defined in the Prisma schema file against the live database and encoding the steps required in migration files.

Some of the current limitations of the tool are:

Building a production-grade schema migrations tool

Once an application is live in production, database uptime and integrity of the live data become really important. Predictability and reliability are some of the fundamental qualities expected from a migration system that can be used in production.

At this stage, developers care about understanding how schema changes will be applied in production, being able to collaboratively review (and influence) migration strategies and replicate changes across environments in a predictable way that does not comprise data integrity and database availability. This means:

We want to enable developers to use Prisma in a production environment by delivering a tool they can trust their migrations with.

Our goal

We are working towards a version of Prisma Migrate that addresses these limitations and shortcomings and meets the expectations of our users for a system that they can trust to migrate their production environments.

Status

Hello! Prisma Migrate was released in General Availability today in version 2.19.0!