Baselining is the process of initializing a migration history for a database that:
- ✔ Existed before you started using Prisma Migrate
- ✔ Contains data that must be maintained (like production), which means that the database cannot be reset
Baselining tells Prisma Migrate to assume that one or more migrations have already been applied. This prevents generated migrations from failing when they try to create tables and fields that already exist.
Note: We assume it is acceptable to reset and seed development databases.
Baselining is part of adding Prisma Migrate to a project with an existing database.
When you add Prisma Migrate to an existing project, your initial migration contains all the SQL required to recreate the state of the database before you started using Prisma Migrate:
You can edit the initial migration to include schema elements that cannot be represented in the Prisma schema - such as stored procedures or triggers.
You need this initial migration to create and reset development environments:
However, when you
prisma migrate deploy your migrations to databases that already exist and cannot be reset - such as production - you do not want to include the initial migrations.
The target database already contains the tables and columns created by the initial migration, and attempting to create these elements again will most likely result in an error.
Baselining solves this problem by telling Prisma Migrate to pretend that the initial migration(s) have already been applied.
To baseline a database:
Ensure that you have updated your development environment and generated initial migrations. Note the names of the migrations that should be skipped - for example:
prisma migrate resolvecommand for each migration that should be ignored:$npx prisma migrate resolve --applied 20210426141759_initial-migration-for-db
This command adds the target migration to the
_prisma_migrations table and marks it as applied. When you run
prisma migrate deploy to apply new migrations, Prisma Migrate:
- Skips all migrations marked as 'applied', including the baseline migration
- Applies any new migrations that come after the baseline migration