Has anyone successfully migrated data from sqlite to postgresql?

Questions and Answers
12

[UPDATE] Here is a video that walks you through how to migrate your database from Sqlite to PostgresQL https://youtu.be/ROvjBdI8-MM?feature=shared

You can also use DTS to make this update locally.

  1. use strapi export to export and back up your data.
  2. configure postgreql based on the docs in your local environment
  3. use strapi import to import your backup to your postgresql db instance.

I am in the process creating a guide that explains this in more detail.