I’m considering a migration to v2. Can anyone tell me if it’s better to introspect my old prisma server or if I should start a new, normalized MySQL DB from scratch and write a script to move the data?

Hey Craig, the introspection approach should definitely work! That's what we've created a lot of content for and also built the Prisma Upgrade CLI to help ironing out some of the issues of the introspected schema.

I’ve no doubt it works, I just have some concerns about now having to manage a database based on the introspection of one I didn’t create myself.

I would suggest you take a look at the Introspection result - it should be quite easy to get that, and then you can see how sane the resulting Prisma Schema is. In my experience often the Prisma Schema is easier to understand and make sense of than the SQL dump tbh - and I spent a lot of time with SQL in the last few years.

@janpio you are right looking into Prisma schema more easier looking to SQL schema

Thanks, all. I’ll give it a whirl.