I've been having nothing but pain with MySQL as far as getting backup jobs to run. This has prompted me to consider switching to MSSQL which in my opinion has some administrative advantages.
At any rate, does anyone have suggestions about how to convert the database into MSSQL 2000/2005 format?
Thanks.
How To Convert from MySQL to MSSQL?
Moderators: Developer, Contributor
-
- Posts: 40
- Joined: 07 Jun 2006, 16:33
Navicat
That doesn't look open source (ie. free). The only reason I'm using MySQL is due to it's cost. We already have MSSQL 2005 in house, so adding another db is free.
Thanks for the idea though.
Thanks for the idea though.
Hello,
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 hou 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.
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 hou 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.
I've created a wiki page for this. I would appreciate if we put some more details into the Wiki page and make sure the steps are details and clear. It would help to have some screenshots and step-by-step guide.
http://wiki.mantisbugtracker.com/doku.p ... l_to_mssql
Once a user is logged into the bug tracker (http://bugs.mantisbugtracker.com), the user is automatically logged into the Wiki with ability to edit existing pages.
Thanks a lot,
Victor.
http://wiki.mantisbugtracker.com/doku.p ... l_to_mssql
Once a user is logged into the bug tracker (http://bugs.mantisbugtracker.com), the user is automatically logged into the Wiki with ability to edit existing pages.
Thanks a lot,
Victor.
Re: How To Convert from MySQL to MSSQL?
Sorry, I didn't get the last 2 steps.
Where do I have to select the odbc connection as source db?
Inside the MS SQL Server Management Studio? If yes, where can I connect to odbc sources there?
Where do I have to select the odbc connection as source db?
Inside the MS SQL Server Management Studio? If yes, where can I connect to odbc sources there?