mantisbt:mysql_to_mssql
Differences
This shows you the differences between two versions of the page.
| Next revision | Previous revision | ||
| mantisbt:mysql_to_mssql [2006/10/02 20:05] – created vboctor | 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.1159833933.txt.gz · Last modified: (external edit)