SQLite to MySQL

Scriptcase 9 General
#1

What’s your favorite method to convert SQLite database into MySQL ?

Any conversion tools to speed up the process ?

  1. converting structure
  2. converting data
#2

The main advantage of using MySQL is the ability to make backups. Or if you have a multi license setup. At the university we have a 10 user license and as SQLite is not meant for mulituser (locks entire table), we got deadlock situations. Fixed by using MySQL (MariaDB).

1 Like