Hello,
Recently we had installed Mantis 2.2.0 version with SQL Server Database. And we had already an old version 1.1.8 but it’s installed with MySQL DB.
Now, I attempt to migrate the Mantis data from MySQL to MSSQL DB. Can you help me know how make that? and the tables to use for migration.
Thanks & Regards,
Data migration from mysql DB to SQL Server DB
Moderators: Developer, Contributor
Re: Data migration from mysql DB to SQL Server DB
I recommend to use the latest stable version as there are major security issues in 2.2.0, see https://www.mantisbt.org/blog/?p=518lazerdev wrote:we had installed Mantis 2.2.0
You have to upgrade this version to 2.x.x. After that you can migrate the MySQL tables to SQL Server.lazerdev wrote:we had already an old version 1.1.8
There are various tools available to migrate MySQL to SQL Server, e.g. https://docs.microsoft.com/en-us/sql/ss ... mysqltosql
I never used one of them and can't tell you more about it.
I can't recommend SQL Server to run Mantis as none of the current core developers is using it.
You will not get that much support in case of problems.