We need an option in Scriptase or a tool to be able to migrate it to a better an stronger DB, like MySQL, Maria DB or even MSSQL
Yes I am looking for it too.
Thank you Georgio, I know how to convert the database, what I don’t know is what to do so that Scriptcase use MySql instead of SQLite as it internal DB
If you manual install in Debian there is a choice to define wich server/DB to use as repository.
Otherwise after choosen SqLite installation, if you want to change follow these stepe:
- 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
I hope I remember everything.
2 Likes
I will try, thank you
hi,
does the migration procedure work? have you tried? Is SC a little faster?
anyone use this with MYSQL or MariaDB?
are there any particular problems?
No I didn’t do it, the conversion from SQLlite to MariaDB is a lot of work and I don’t have enough time to do it
It is not that hard and not so tricky as SC now supports it during installation time. If you are the only user then there is not much to gain, although sometimes SQlite might get corrupted. But creating backups is always the key here. On multiuser environments (more devs on Scriptcase) then a ‘real’ database like MySQL or MariaDB is advises. SQLite is not mulituser, and locks on data table level causing issues with multiple licenses.
Is there a guide on how to do this?
my sqlite db has become almost 2GB, I would like to migrate it to mysql