best way to export MySQL database to SqlServer database [duplicate]

Question

I have a MySQL database, i need that database in MS SqlServer. What is the best way to do this?

AmmarR · Accepted Answer · 2012-05-15 08:06:14Z

3

there are few methods out there like

install mysql driver --> connect to mysql using ODBC --> create a link server --> use openquery

another method export from mysql to excel worksheet and then import the excel worksheet.

the method i usually use, and which i think is the reliable for me, is a manual and lengthy process

i use phpmyadmin to export the DB in a sql script

and than i manually tweak the script

like for example change the table name to [tablename] and other sql syntax etc

answered May 15, 2012 at 8:06

AmmarR

2482 silver badges11 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1