Page 1 of 1

Migration Mysql to MSSQL

Posted: 19 Feb 2020, 06:00
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

Re: Migration Mysql to MSSQL

Posted: 24 Mar 2020, 19:25
by TerranceM
Follow the steps for the Mysql to MSSQL migration.

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

Re: Migration Mysql to MSSQL

Posted: 20 Apr 2020, 19:49
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.