Looking for someone that can export a Microsoft SQL Server database to be imported into MySQL, preferably providing us with a mysql dump to be imported directly into our mysql server.
We've attempted several different export types from Microsoft SQL Server Management Studio and all have failed on export or failed on import into mysql.
- MS Excel
- MS Access
- Flat File
In our latest attempt we used MySQL Workbench to try migrating the SQL database to MySQL. This process fails on the "Reverse engineer selected schemata" with the error below. It seems that the data in some of our tables may be incompatible with the export tools and/or corrupt. When we do successfully export the data using excel we get errors on import into mysql.
We would like to have you isolate the errors so that they can be fixed. We will need to process this once to get all of the tables and then have the ability to download and import the database once the new website is live in order to pull all of the most recent information.