|
Does Drift have an easy to use way to migrate between database systems? Or will I be required to hack together a solution myself? |
Answered by
simolus3
Feb 17, 2026
Replies: 1 comment
|
There is no built-in migration from SQLite to PostgreSQL in drift. In terms of hacking something together, you could start using PostgreSQL with an existing drift database (see postgres support), and then open two instances of your database to start copying tables from SQLite to Postgres. You could also do this offline by using drift to generate a batch of SQL statements doing the writes beforehand with tricks like these used for testing. |
0 replies
Answer selected by
JHubi1
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
There is no built-in migration from SQLite to PostgreSQL in drift.
In terms of hacking something together, you could start using PostgreSQL with an existing drift database (see postgres support), and then open two instances of your database to start copying tables from SQLite to Postgres. You could also do this offline by using drift to generate a batch of SQL statements doing the writes beforehand with tricks like these used for testing.