4 Replies - 4585 Views - Last Post: 27 October 2009 - 06:55 PM

#1 crzyone9584   User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 201
  • Joined: 22-April 08

Mysql to MS Sql Server 2008 Express

Posted 27 October 2009 - 06:10 PM

I'm in the process of making my program a lot easier to use a database. Mysql is just a big pain if you dont have the right permissions. So how would i convert mysql database to MS SQL Server 2008 Express Edition?
Is This A Good Question/Topic? 0
  • +

Replies To: Mysql to MS Sql Server 2008 Express

#2 PsychoCoder   User is offline

  • Google.Sucks.Init(true);
  • member icon

Reputation: 1660
  • View blog
  • Posts: 19,853
  • Joined: 26-July 07

Re: Mysql to MS Sql Server 2008 Express

Posted 27 October 2009 - 06:12 PM

To the best of my knowledge there is no tool for this, you're just going to have to re-create it by hand.
Was This Post Helpful? 0
  • +
  • -

#3 crzyone9584   User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 201
  • Joined: 22-April 08

Re: Mysql to MS Sql Server 2008 Express

Posted 27 October 2009 - 06:17 PM

well them im screwed. I have a nice size database that needs to be transfered :'(
Was This Post Helpful? 0
  • +
  • -

#4 baavgai   User is offline

  • Dreaming Coder
  • member icon


Reputation: 7505
  • View blog
  • Posts: 15,553
  • Joined: 16-October 07

Re: Mysql to MS Sql Server 2008 Express

Posted 27 October 2009 - 06:45 PM

View Postcrzyone9584, on 27 Oct, 2009 - 07:10 PM, said:

Mysql is just a big pain if you dont have the right permissions.


:blink: That would be any database.

View Postcrzyone9584, on 27 Oct, 2009 - 07:10 PM, said:

So how would i convert mysql database to MS SQL Server 2008 Express Edition?


The full version of SQL Server has the Management Studio. It contains an import tool. If you install a mysql OleDb or ODBC adapter, you could probably use the tool.

If you can connect to both databases with standard adapters, there are some tools out there that will copy data. The biggest challenge is schema, which you'd probably want to do by hand anyway.

If you have C# express, you can roll you own migration tool with DataReaders and DataWriters.

If your data fits into nice tab separated columns, you could export it to a flat file from mysql and use BULK IMPORT in sql server express.

You can just generated insert statements from database a and run them against database b.


View Postcrzyone9584, on 27 Oct, 2009 - 07:17 PM, said:

I have a nice size database that needs to be transfered :'(


If it's more the 4GB, SQL Express will not work for you.
Was This Post Helpful? 0
  • +
  • -

#5 crzyone9584   User is offline

  • D.I.C Head

Reputation: 6
  • View blog
  • Posts: 201
  • Joined: 22-April 08

Re: Mysql to MS Sql Server 2008 Express

Posted 27 October 2009 - 06:55 PM

View Postbaavgai, on 27 Oct, 2009 - 05:45 PM, said:

If it's more the 4GB, SQL Express will not work for you.


Its not that big. So the full version has an import toolset. Thank god for msdn and having a school that works with it ^_^ just got to find the full edition lol
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1