mantisbt:mysql_to_mssql
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
mantisbt:mysql_to_mssql [2006/10/05 08:03] – 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 ====== | ====== Moving from MySQL to MS SQL ====== | ||
- | This is an extract from the [[http://forums.mantisbugtracker.com/ | + | This is an extract from the [[http://www.mantisbt.org/forums/ |
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 | + | No big issues, but it's important to remember |
- | 1. install Mantis with SQL server | + | - 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. | 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)