Migration Mysql to MSSQL

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
Posts: 2
Joined: Feb 19, 2020 12:53 am

Migration Mysql to MSSQL

Post by vmungar »

PFB more details of the encoding issue that we faced during the migration.

• The old mantis database was on Mysql and the new migrated database is SQL
server. This was done for better integration of mantis with timesheet.
o All data has been migrated as per the migration report generated
o However the encoding of special French characters (à, ê,.. ) is different in
Mysql and SQL server

Due to this notes are not appearing on mantis.

Please advice

Posts: 20
Joined: Aug 27, 2019 8:55 am
Location: USA

Re: Migration Mysql to MSSQL

Post by TerranceM »

Follow the steps for the Mysql to MSSQL migration.

https://www.sqlshack.com/migrate-mysql- ... ssma-ssis/

Post Reply