How To Convert from MySQL to MSSQL?

Get help from other users here.

Moderators: Developer, Contributor

Post Reply
mcraig88
Posts: 12
Joined: 03 Mar 2006, 21:21
Location: Seattle, WA
Contact:

How To Convert from MySQL to MSSQL?

Post by mcraig88 »

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.
skibumm101
Posts: 40
Joined: 07 Jun 2006, 16:33

Post by skibumm101 »

if administrative duties is your problem, i would look at navicat. it has some great utilities including scheduled backups
mcraig88
Posts: 12
Joined: 03 Mar 2006, 21:21
Location: Seattle, WA
Contact:

Navicat

Post by mcraig88 »

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.
hhetland
Posts: 1
Joined: 29 Sep 2006, 16:24

Post by hhetland »

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.
vboctor
Site Admin
Posts: 1293
Joined: 13 Feb 2005, 22:11
Location: Redmond, Washington
Contact:

Post by vboctor »

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.
timmi
Posts: 9
Joined: 15 Feb 2010, 08:57

Re: How To Convert from MySQL to MSSQL?

Post by timmi »

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?
Post Reply