What’s your favorite method to convert SQLite database into MySQL ?
Any conversion tools to speed up the process ?
- converting structure
- converting data
What’s your favorite method to convert SQLite database into MySQL ?
Any conversion tools to speed up the process ?
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).
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