16

I have a SQL Server database with lots of data and an empty MySQL database. Now I want to copy all data of SQL Server database (including the database schema) to the MySQL database.

I thought about using raw SQL dump, but SQL Server's SQL syntax is not same as MySQL.

And I have googled some database migration tool, such as south (only for django), simple-db-migration (only for one type of database, maybe PostreSQL?) and SQLAlchemy (I haven't finished learning it, just feeling it somewhat clunky).

What tool can I use to do this migration?

Improve this question
1
  • you can use MySQL Workbench To migrate from MSSQL to MySQL Commented Jun 9, 2017 at 8:53

2 Answers 2

Reset to default
19

I'm usually using opendbcopy for these kind of jobs ...

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

1 Comment

Is this still preferred? Thanks
1

I tried this tool once http://dbconvert.com/convert-mssql-to-mysql-pro.php , but you have to pay for the full version. Of course you can write your own migration script e.g. in PHP. On Windows it will be easy to connect to MSSQL server, from a Linux machine you have to use ODBC and that is sometimes a bit messy to install and configure.

Improve this answer

1 Comment

I am too searching for this type of tool like i have database in Mysql or oracle or Excel and i want to take database from any of this sources and dump that database in my local sql server.can you please guide me a little about this tool?

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.