Javascript Disabled Detected

You currently have javascript disabled. Several functions may not work. Please re-enable javascript to access full functionality.

MSSQL to MySQL

Started by Roopa2332, Nov 30 2007 05:04 PM

This topic has been archived. This means that you cannot reply to this topic.

4 replies to this topic

#1
Roopa2332

Posted 30 November 2007 - 05:04 PM

Newbie

Members
3 posts

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.

#2
Guest_Jordan_*

Posted 01 December 2007 - 06:21 AM

Guests

The dump will work fine.

#3
Roopa2332

Posted 02 December 2007 - 08:42 AM

Newbie

Members
3 posts

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.

#4
OffShoreOutsourcingHelp

Posted 02 December 2007 - 04:06 PM

Newbie

Members
1 posts

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.