SQLite to MariaDB script

[henrikkoch]

It would be nice if a script existed to convert the app.dk (SQLite) database to inject it into a MariaDB file. I have tried using only tools, but it doesn't work out.

[tobiasfalk]

Would also be interested in something like this, but with Postgresql

[d-buchmann]

For Postgres, you should have a look at pgloader.

[d-buchmann]

What tool(s) did you use? What errors/problems occurred?
I found this, and though I have not looked into it in detail, it claims to do exactly what you asked for.

[henrikkoch]

I used an online tool: https://www.rebasedata.com/convert-sqlite-to-mariadb-online This is how it ended up <img width="2704" height="1065" alt="image" src="https://github.com/user-attachments/assets/3d19aced-dc50-4475-b750-330913efe2ee" /> And here some of my trials with setting up the DB <img width="1534" height="721" alt="image" src="https://github.com/user-attachments/assets/b71ab35e-7400-415f-99eb-e6c86b91e993" />

[jbtronics]

There is now a console command to do that.

https://docs.part-db.de/installation/choosing_database.html#converting-between-database-platforms