How To Convert from MySQL to MSSQL?

Get help from other users here.

Moderators: Developer, Contributor

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

How To Convert from MySQL to MSSQL?

Post by mcraig88 » Sep 25, 2006 4:24 pm

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: Jun 07, 2006 11:33 am

Post by skibumm101 » Sep 25, 2006 5:19 pm

if administrative duties is your problem, i would look at navicat. it has some great utilities including scheduled backups

mcraig88
Posts: 12
Joined: Mar 03, 2006 4:21 pm
Location: Seattle, WA
Contact:

Navicat

Post by mcraig88 » Sep 26, 2006 2:51 pm

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: Sep 29, 2006 11:24 am

Post by hhetland » Sep 29, 2006 11:30 am

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: 1286
Joined: Feb 13, 2005 5:11 pm
Location: Redmond, Washington
Contact:

Post by vboctor » Oct 02, 2006 7:07 pm

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: Feb 15, 2010 3:57 am

Re: How To Convert from MySQL to MSSQL?

Post by timmi » Feb 15, 2010 8:13 am

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