- Is there a way to have multiple schema.prisma fi...
# orm-helpr
Rodrigo Scomação do Nascimento
09/01/2021, 7:00 PM• Is there a way to have multiple schema.prisma files? One for dev, one for prod and one for testing. I'd like to use sqlite for testing and MySQL for dev/prod...
r
Ryan
09/02/2021, 5:41 AM@Rodrigo Scomação do Nascimento 👋
You can do it in the following way; https://github.com/prisma/prisma/issues/2443#issuecomment-630679118
r
Rodrigo Scomação do Nascimento
09/02/2021, 3:31 PMOh thanks for that! It actually looks less hacky! 😃
Rodrigo Scomação do Nascimento
09/02/2021, 3:44 PMJust tried it, and it clashes with the `migration_lock.toml`:
Copy code
The datasource provider `sqlite` specified in your schema does not match the one specified in the migration_lock.toml, `mysql`. Please remove your current migration directory and start a new migration history with prisma migrate dev. Read more: <https://pris.ly/d/migrate-provider-switch>r
Ryan
09/03/2021, 6:09 AMTry keeping the schemas in two separate folders so that migrations don’t conflict with each other.
8 Views