SQLite to MySQL

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

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

I did it with manually creating MySQL db (starting from SQLite schema)
and then import with DBEaver (it’s free)

Migrate the DB nm_scriptcase. from SqLite to MySql/MariaDb
In SC9 root directory there is a file named config_.php.
Rename it to config.php and just run it from a browser.
Rename config.php to config_.php

You can also export your projects

Do a fresh install of Scriptcase, choosing the mySQL instead of the default SQLite

Then reimport your project.

That way you are sure that everything is clean, even Scriptcase