Option to migrate scriptcase from SQLite to MySQL/Maria DB

Scriptcase 9 Suggestions
#1

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

#2

Yes I am looking for it too.

#3

Follow this guide

From Sqlite to MySql

#4

Here a schema in MariaDB for Scriptcase 9.9.007
mysql_schema.zip (3.1 KB)

#5

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

#6

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
#7

I will try, thank you