Convert MSSQL database to MySQL database

[sarang_k]

Hi all, How can i convert MSSQL database to MySQL database ? Thanks in advance.

[David Skelly]

I would start by going to Google and typing "convert mssql to mysql". That gives over 2 million hits. At least one of them must be useful.

[Lost User]

The simplest way is to use the 'Generate Scripts' option in MSSQL and create the full script for the database and all its objects (including the data in the tables), then adapt the resulting script to MySQL syntax and run it on the MySQL database.

[obhijitghosh]

Convertion of MSSQL database to MySQL database can mean a lot of things. Migration of Tables and Data. Migration of stored proc, triggers etc. Doing the first one is relatively easy and less labour intensive and can be done in a lot of ways. One example would be first to generate the create table scripts and edit them to suit MySQL. Execute these to create the tables in MySQL. Export the data from MSSQL to MySQL. Lastly apply the foreign keys. For each of these steps, there are tools available. The below mentioned link may help you. http://kofler.info/english/mssql2mysql/[^] -- obhijitghosh