Theme: Component database
Does MariaDB or MS-SQL also work instead of MySQL?
The TARGET component database works in a network with MySQL 5.1.12 to 5.7 if you do not use SQLite locally (default). MS-SQL unfortunately does not work. MariaDB is supposed to be compatible with MySQL for the most part. However, there are unfortunately problems when using it with TARGET. A customer now wrote us the following:
"I have now recreated the database at MariaDB and imported the dump with the empty database. Afterwards, I carried out an online DB update in the component browser directly via TARGET and thus filled the database. As described, this took a long time, but now the database seems to work correctly with MariaDB."
Another user writes:
"I use Maria DB 10.11 without problems:
# mysql --version
mysql Ver 15.1 Distrib 10.11.6-MariaDB, for debian-linux-gnu (x86_64) using EditLine wrapper""