How to migrate a SQLServer 2012 database to MySQL?

1

I need to perform the migration of a SQLServer 2012 Database to MySQL for this I tried the information in this post: link

But it only works for SQLServer 2008.

Then I tried OpenDBCopy link

Then try to do what is indicated in this post with workbench : link

None of these solutions worked.

    
asked by juanitourquiza 21.07.2017 в 02:32
source

1 answer

3

To solve this problem, what I did was to copy the structure of the database.

In the SQLManager you are looking for the database. Then Tasks - Generate Scripts

Then using this site: link

Transform the query, do it quite well and create the structure of the database for MySQL

To copy the data: - I make a select to the whole table - I copy the records to a file .csv - With PHPMyAdmin I import them to MYSQL

The process was delayed 2 days but it turned out well.

I did this with tables even of up to 150,000 records and it worked fine, I loaded the PHPMyAdmin up to 10,000 records

I hope you help them.

Greetings

    
answered by 21.07.2017 / 02:32
source