Migrating Mantis from MSSQL to MySQL

[DiamondEagle]

Once upon a time a long time ago I installed Mantis 1.1.8 using MS SQL Server 2005 as the Mantis database. Over the years I've collected a lot of bug reports for my projects and done a lot of work with Mantis. Mantis rocks!

But using MSSQL was a big mistake. Upgrading Mantis has been impossible with MSSQL, so I would like to migrate from MSSQL to MySQL. Is there any documentation on how I should do this? How do I migrate my existing data in the MSSQL database to a MySQL database?

Thanks.

[atrol]

Might work, never tried step 2) myself:

1) Install empty MantisBT 1.1.8 using MySQL (this is needed to have the right database schema and not a schema that is generated by any MSSQL-->MySQL migration tool)
2) Use a tool to migrate the data from MSSQL to MySQL, e.g. http://opendbcopy.sourceforge.net/
3) Upgrade MantisBT 1.1.8 to 1.2.19 by following the instructions at https://www.mantisbt.org/docs/master-1. ... LL.UPGRADE

[slotix]

Hello,

Try https://dbconvert/mssql/mysql/ for migration. It checks for possible migration issues before actual conversion.