Moving from MySQL to MS SQL

This is an extract from the forums. I'm hoping it will be revised and detailed later, but it can be a good start.

Just converted from mysql using the mysql odbc connector and copying table by table in SQL Server Management Studio.

No big issues, but it's important to remember to allow for “identity inserts” when you select the table to insert to.

  1. install Mantis with SQL server
  2. install mysql odbc connector
  3. setup a odbc connection in Data Sources under administrative tools
  4. use that connection when selecting source database
  5. copy table by table from mysql to sql server

I have one issue and that is that dates is not displayed correcly in mantis. Guess it's a small issue.