Feature/Investigate: Add a way to migrate from one database type to another

[pglombardo]

🚀 Feature Request

We may be making SQLite3 the default database soon as filed in #3799.

We should investigate if it's possible for users to migrate from one database type to another. We can also use this in Password Pusher Pro.

For SQLite3 --> PostgreSQL - there is pgloader which supports this:

Supported operations include:

Migrate from MySQL to PostgreSQL
Migrate from SQLite to PostgreSQL
Migrate from MS SQL Server® to PostgreSQL

But for PostgreSQL --> SQLite3, there are no current tools as far as I can tell.

A pg_dump SQL file has syntax that SQLite3 doesn't recognise so manual editing of the .sql file would be needed:

sed -i '/^SET/d' pwpush_dump.sql
sed -i '/^CREATE SCHEMA/d' pwpush_dump.sql
sed -i 's/SERIAL/INTEGER PRIMARY KEY AUTOINCREMENT/g' pwpush_dump.sql

So research needed.