Hey everyone! I had a question about upgrading fro...
# orm-help
s
Hey everyone! I had a question about upgrading from Prisma 2.22.1 to the latest version (3.9.1). It seems when I run
migrate 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!