Some notes for swapping database providers. I moved from SQLite to Postgres, as well as changing up the schema during that same time. Overall this was a bad approach… modifying multiple variables in a complex system isn’t great for debugging if things don’t work right.
Please learn from my mistake. In this scenario - I recommend changing the provider first and making sure everything is good there before changing any parts of the schema. Test the app with the new database, test the business logic, etc. before moving on to any schema changes.
Also, you will have to archive or delete the Migrations folder created using SQLite provider. See the link below.