I'm trying to convert from a MSSQL .bak database to MYSQL. This question and answers have been very useful, and I have successfully imported the database, but am now stuck on exporting to MYSQL.
The MYSQL Migration Toolkit was suggested, but seems to have been replaced my the MYSQL Workbench. Is it possible to use the MYSQL Workbench to migrate from MSSQL in the same way that the migration tool worked?
Or is the Migration Toolkit still available somewhere?
It looks like you correct: The Migration Toolkit is due to be integrated with MySQL Workbench - but I do not think this has been completed yet. See the End-of-life announcement for MySQL GUI Tools (which included the Migration Toolkit):
http://www.mysql.com/support/eol-notice.html
MySQL maintain archives of the MySQL GUI Tools packages:
I have used MySQL Migration Toolkit on the server where our MS SQL db is and used it to attempt to migrate to MySQL database server. It seems to work, but after sometime trying to verify the migration it seems there's issues!
Everyone kept telling me to use mysql-workbench because it was "the tool" for what I was trying to do.
Today I installed Mysql-workbench 5.2.29 on both a Linux machine and a Windows machine, and no where have I found a way to perform the migration with workbench. I don't even see a way to connect to a MS SQL database using port 1433. I clicked everywhere and attempted several things but it kept failing to connect to my Source MS SQL database server.
I could get it to connect to the Destination mysql server fine, but can't figure out a way or any docs, howtos, info for how to perform the Migration from MSSQL to MySQL with workbench anywhere...
I spent last 2 days working on this, some building on rhel5 server.