Migration Mysql to MSSQL

General discussion of Mantis.

Moderators: Developer, Contributor

Post Reply
vmungar
Posts: 2
Joined: 19 Feb 2020, 05:53

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
TerranceM
Posts: 26
Joined: 27 Aug 2019, 13:55
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/
TerranceM
Posts: 26
Joined: 27 Aug 2019, 13:55
Location: USA

Re: Migration Mysql to MSSQL

Post by TerranceM »

Download and install the MySQL ODBC Connector.
Open your ODBC Data Source Administrator from the Control Panel -> Administrative Tools. On the System, DSN tab click 'Add', browse the 'MySQL ODBC driver' and click 'Finish'.
In the next dialog enter your MySQL server connection details, test it and click OK.
Set SQL_MODE to ANSI_QUOTES on MySQL Server.
Launch the SQL Server Management Studio
Create a new database or use an existing database
Right-click on the target database and choose Tasks then click Import Data to launch the SQL Server Import and Export Wizard.
Select the .NET Data Provider for ODBC as Data Source and specify the DSN we created previously.
Select SQL Server Native Client 10 as Destination, enter the details of your SQL Server database and click Next.
Select Copy data from one or more tables or views and click Next.
Select the source and destination tables. You can enable identity insert using the Edit Mappings option.
Finally, execute the package and save it for later use if necessary.
Post Reply