Shayne Czyzewski
02/07/2022, 6:44 PMmigrate dev
after upgrading, it wants to create a new migration on existing SQLite and PostgreSQL databases. For SQLite, it wants to recreate all my tables (by creating a new migration basically with -- RedefineTables
and -- RedefineIndex
). For PostgreSQL, it does -- DropForeignKey
, -- AddForeignKey
, and -- RenameIndex
(that I have seen so far).
My main question is, is this expected and I should just add the new migration when upgrading (vs some other approach)? Any other tips/considerations to help migrate existing databases between these major versions? I did see this: https://www.prisma.io/docs/guides/upgrade-guides/upgrading-versions/upgrading-to-prisma-3 Thanks!