All geek questions in one place

Convert from Microsoft SQL Server to MySQL

How to convert a Microsoft SQL Server database backup file to import into a MySQL database? Is there a way or a free tool for this?

+6
source share
4 answers

Not sure how complicated your database is, but if it has only some tables and data, here is a free script here that automatically converts Microsoft SQL Server tables and data to MySQL.

If you need something more complex, then MySQL has a set of migration tools that allows you to migrate from Microsoft SQL Server to MySQL. In addition, here is a tutorial on how to use it. Note that this has now been discontinued, in favor of MySQL Workbench , in which data transfer .

In addition, this converter converts everything except stored procedures from MSSQL to MySQL, at a price of only $ 50, which is not bad.

You can also check out this document on the MySql website on how to plan your migration from SQL Server to MySQL, as well as some resources.

+19
source

ms2my (pre-alpha, free) http://sourceforge.net/projects/ms2my/

"A tool that helps with MSSQL to MySQL convert / replicate (both csv & dump) to * nix. Allows you to use it with crontab to collect data regularly. Saving an updated data warehouse based on mySQL can also be one of the possibilities of using this script."

MSSQL to MySQL converter (free trial, for purchase $ 49) http://www.convert-in.com/mss2sql.htm

I searched for quite a while, and if you do not want to try ms2my, then the above applies to the only other option. And it's not free.

Good luck finding free, I hope there is one that is hidden there on the Internet, which I can not find.

+2
source

If you are using live MS SQL Server and live MySQL server, then I think your best AND MORE ACCURACY option is to use an ETL / data conversion tool such as Pentaho Data Integration ( Kettle ).

With Kettle, you can visually construct (using easy-to-learn data flow steps) virtually any data conversion from one / several data sources (s) to one or more data destinations. One of the features that may interest you is the Database / Table Migration Wizard.

If the distribution of the Kettle community is not enough for you, you can use the Enterprise Edition with a lot of features, support, etc.

0
source

Take a look at Omega Sync , it supports export import and synchronization between various DBMSs, including schema data and tables.

0
source

Source: https://habr.com/ru/post/892035/

More articles:


All Articles