Has anyone successfully migrated data from sqlite to postgresql?

Questions and Answers
13

Thanks for the tutorial @Paul_Brats , but there are some disadvantages in this method:

  • Admin users and API tokens are not exported.
  • If you have lifecycles.js file to listen to record changes, you should disable it before importing. In my case, I listen to new record and save the changes to another table.
  • The record ID will not maintain: If your table has 4 records: [{id: 1}, {id: 2}, {id: 4}, {id: 5}], the new table after importing will be: [{id: 1}, {id: 2}, {id: 3}, {id: 4}].
    So be aware before import/export using strapi import

In my case, I have to use sequel to transfer database, and then write some functions more to convert some field (eg: createdAt) before use.

1 Like