Setting the file. One moment.
Subchapter 1.15
references/migrate-diff.mdMarkdown2 KBView on GitHub
prisma migrate diff [options]--from-... and --to-...)empty)schema)migrations)url) or Configured Datasource (config-datasource)--script)| Option | Description |
|---|---|
--script | Render SQL script to stdout |
--exit-code | Exit 2 if changes detected, 0 if empty, 1 if error |
--config | Custom path to your Prisma config file |
--from-empty, --to-empty--from-schema <path>, --to-schema <path>--from-migrations <path>, --to-migrations <path>--from-url <url>, --to-url <url>--from-config-datasource, --to-config-datasource (uses prisma.config.ts)Compare current production DB to your local schema:
prisma migrate diff \
--from-url "$PROD_DB_URL" \
--to-schema ./prisma/schema.prisma \
--scriptCompare database state to migrations directory:
prisma migrate diff \
--from-config-datasource \
--to-migrations ./prisma/migrationsCompare empty state to current schema:
prisma migrate diff \
--from-empty \
--to-schema ./prisma/schema.prisma \
--script > prisma/migrations/0_init/migration.sqlCheck if database matches schema:
prisma migrate diff \
--from-config-datasource \
--to-schema ./prisma/schema.prisma \
--exit-codemigrate dev.migrate dev would do.