Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
- - - - -

MSSQL to MySQL

MS SQL mysql mssql

  • Please log in to reply
4 replies to this topic

#1 Roopa2332

Roopa2332

    CC Lurker

  • Just Joined
  • Pip
  • 3 posts

Posted 30 November 2007 - 05:04 PM

Hi... I have a backup of my MSSQL database. I want to migrate it to mySQL at a later time. Is it just a simple dump from the existing database backup or do I need the actual database with the table structures in MSSQL at the time of migration?

Early response appreciated.

Thanks,
Roopa.
  • 0

#2 Guest_Jordan_*

Guest_Jordan_*
  • Guest

Posted 01 December 2007 - 06:21 AM

The dump will work fine.
  • 0

#3 Roopa2332

Roopa2332

    CC Lurker

  • Just Joined
  • Pip
  • 3 posts

Posted 02 December 2007 - 08:42 AM

Hi Jordan,

Thank you for your reply. I really appreciate it. So you say that the backup of the database would be enough for the dump.

Please clarify. That would be really helpful.

Thanks,

Roopa.
  • 0

#4 OffShoreOutsourcingHelp

OffShoreOutsourcingHelp

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 02 December 2007 - 04:06 PM

To convert from MSSQL to MySQL, I have always used the 'MySQL Migration Toolkit'. You need to point it to your SQL Server database.

When you're ready to convert, just restore the database backup ( you can use SQL Server Express, with SQL Server Management Studio) and then point the MySQL Migration Toolkit to your SQL Server database.
  • 0

#5 Guest_NeedHelp_*

Guest_NeedHelp_*
  • Guest

Posted 03 December 2007 - 07:17 AM

You could also use Access to map the data from MSSQL to MySQL.
  • 0





Also tagged with one or more of these keywords: MS SQL, mysql, mssql

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download