User Tools

  • Logged in as: anonymous (anonymous)
  • Log Out

Site Tools


mantisbt:mysql_to_mssql

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
mantisbt:mysql_to_mssql [2006/10/05 08:03] leblancmamantisbt: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 ====== ====== Moving from MySQL to MS SQL ======
  
-This is an extract from the [[http://forums.mantisbugtracker.com/viewtopic.php?t=2022|forums]].  I'm hoping it will be revised and detailed later, but it can be a good start.+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. 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 remeber to allow for "identity inserts" when you select the table to insert to.+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 +  - install Mantis with SQL server 
-2. install mysql odbc connector +  install mysql odbc connector 
-3. setup a odbc connection in Data Sources under administrative tools +  setup a odbc connection in Data Sources under administrative tools 
-4. use that connection when selecting source database +  use that connection when selecting source database 
-5. copy table by table from mysql to sql server+  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. I have one issue and that is that dates is not displayed correcly in mantis. Guess it's a small issue.
 +
mantisbt/mysql_to_mssql.1160049786.txt.gz · Last modified: 2008/10/29 04:31 (external edit)

Driven by DokuWiki