Empty migration when baselining a database

npx prisma migrate diff \
--from-empty \
--to-schema-datamodel prisma/schema.prisma \
--script > prisma/migrations/0_init/migration.sql

npx prisma migrate diff \
--from-empty \
--to-schema-datamodel prisma/schema.prisma \
--script > prisma/migrations/0_init/migration.sql

but the migration.sql is empty

-- This is an empty migration.

-- This is an empty migration.

What am I missing here?

How to initialize a migration history for an existing database that contains important data.

Prisma•12mo ago•

4 replies

npx prisma migrate diff \
--from-empty \
--to-schema-datamodel prisma/schema.prisma \
--script > prisma/migrations/0_init/migration.sql

npx prisma migrate diff \
--from-empty \
--to-schema-datamodel prisma/schema.prisma \
--script > prisma/migrations/0_init/migration.sql

but the migration.sql is empty

-- This is an empty migration.

-- This is an empty migration.

What am I missing here?

How to initialize a migration history for an existing database that contains important data.