Data migration from mysql DB to SQL Server DB

[lazerdev]

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,

[atrol]

we had installed Mantis 2.2.0

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=518

we had already an old version 1.1.8

You have to upgrade this version to 2.x.x. After that you can migrate the MySQL tables to SQL Server.

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.