horilla
horilla copied to clipboard
horilla-opensource
Migrate data from sqlite to MySql
How to migrate data from sqlite to MySql. without losing anything. Is this possible to be done with horilla.
Hi @edmir31 , There is no direct method in Horilla to migrate the database from sqlite to MySQL. As an alternative we suggest you to use PostgreSQL database as it is much faster and also MySQL databases are having some issues with some tables in the system. In case of PostgreSQL, you can create a dump file of the sqlite database and feed it into Postgres database. Please refer the below link. How to convert SQLite SQL dump file to PostgreSQL?
With Regards, Team Horilla
Hi @edmir31 , We are closing this issue due to inactivity. It seems that there hasn't been any recent activity or discussion, and we believe it may have been resolved or is no longer relevant. If you feel this issue is still important and should be addressed, please feel free to reopen it or create a new issue with updated details.
With Regards, Team Horilla
I would like to provide some insight what one has to expect to migrate from sqlite to mysql. Getting started is easy. Use the same application version like the one importing from. After the database is created create the tables by executing the database migration steps. This works around modifying the sqlite table definitions. On my version there are 256 tables. Then remove the "create table" instructions from the dump. Now the data can be imported. Many tables have foreign key constraints, that is why some table have to be imported first. Other tables have a different table structure inside sqlite compared to mysql. The data might also differ for some fields. This requires editing the values. Depending on the size of the data, time and motivation it could be doable or not. At two time entries per day per person, with five users and 20 workdays per month these 200 entries per month.
