Quickest way to convert MS SQL to MYSQL?

Forum Moderators: open

Message Too Old, No Replies

Quickest way to convert MS SQL to MYSQL?

TheVanWarehouse

10:23 am on May 26, 2009 (gmt 0)

Hi,

I'm looking for the fastest way to convert a MS SQL database (roughly 3 GB) to a MYSQL database.

I have Microsoft SQL Server Management Studio Express (and Microsoft SQL Server 2005) installed on my local machine (where the conversion will happen) and MySQL.

I tried using a mss2sql script - however it was taking over a day to convert the database.

I thought it might be quicker to export the raw sql using Microsoft SQL Server Management Studio Express then use something like BigDump to import the data to MySQL - but I'm not sure if this would work and can't see any export option.

Does anyone have suggestions on the best (i.e. fastest) way to do the conversion? Thanks

abidshahzad4u

2:06 pm on May 28, 2009 (gmt 0)

I don't know about tools but you can do this like

first export the data to .csv or excel format and then import this to the mysql. May be you have to play little with php.

Demaestro

3:14 pm on May 28, 2009 (gmt 0)

There is a list of migration tools and an overview of each on the MySql website. About half way down is the migration overview.

There are a wide variety of tools available to help you migrate a SQL Server or Access database to MySQL. We'll look at several different tools so you can choose the one that best suits your needs. The tools we will look at will include the following:
* MSSQL2MYSQL
* Microsoft DTS
* SQLyog
* Access Export
* Text Import/Export

[dev.mysql.com...]

wonn1377

8:13 am on Aug 26, 2009 (gmt 0)

I think u should use a third party help to resolve this problem, i use dbload to solve it when i was migrated my data, it can migrate almost any data, it helps me to convert MSSQL to MYSQL, MS access to MSSQL, mysql, csv loader, foxpro and MSSQL to MS access, MYSQl, CSV, foxpro etc. i found it on google search.

Download Free : [dbload.com...]