Differences

This shows you the differences between two versions of the page.

--- mantisbt:mysql_to_mssql [2006/10/05 09:09] – Converted list items to display correctly, also corrected 2 typos leblancma
+++ mantisbt:mysql_to_mssql [2011/11/16 07:34] (current) – The page rendering was broken (maybe since new PHP version on mantisbt.org). Added new line to fix it at end of file. atrol
@@ Line 1: / Line 1: @@
+====== Moving from MySQL to MS SQL ======
+This is an extract from the [[http://www.mantisbt.org/forums/viewtopic.php?t=2022|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.
+  - install Mantis with SQL server
+  - install mysql odbc connector
+  - setup a odbc connection in Data Sources under administrative tools
+  - use that connection when selecting source database
+  - 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.