Menu
I have a .sql file from a MySQL dump containing tables, definitions and data to be inserted in these tables. How can I convert this database represented in the dump file to a MS SQL Server database?
874
If you go to the destination database in SSMS and right-click, in the task list there should be an option called Import Data. It's essentially a wizard that makes an SSIS package for you, which can either run immediately or be saved and modified later as needed.
Drivers. Fortunately, you can find connection drivers for almost any popular language just by searching the web. This allows you to easily connect to both MySQL and MSSQL without the need for complicated coding. MSSQL Server was introduced in 1989, while MySQL was introduced in 1995 as an open-source project.
Use SQL Server Migration Assistant (SSMA)
In addition to MySQL it supports Oracle, Sybase and MS Access.
It appears to be quite smart and capable of handling even nontrivial transfers. It also got some command line interface (in addition to GUI) so theoretically it can be integrated into some batch load process.
This the current download link for MySQL version https://www.microsoft.com/en-us/download/details.aspx?id=54257
The current (June 2016) stable version 6.0.1 crashes with the current (5.3.6) MySQL ODBC driver while transferring data. Everything 64 bit. The 5.3 version with the 5.1.13 ODBC driver works fine.
57
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
