I have a database schema from MySQL which I want to import to SQL SERVER, I have tried dumping from MySQL with compatibility for SQL Server, but with no success. Tried dumping as Excel still no dice. Does anyone know another way to import this database with no records from MySQL to SQL SERVER 2012? Thanks for your time.
- Anybody can ask a question
- Anybody can answer
- The best answers are voted up and rise to the top
I recently had to do essentially the same thing, except that I wanted to migrate MySQL tables and data to SQL Server. I tried:
The only method that didn't fail outright was to pull the tables from MySQL into a Microsoft Access .mdb file (!) via MySQL ODBC, then import that into SQL Server.
However, even that was an incomplete solution because the transfer from MySQL to Access omitted all of the primary keys, indexes, and AUTO_INCREMENT attributes. Still, it did transfer the tables and data, which was my main objective. I just had to write some T-SQL to re-create the indexes and whatnot.
Since you don't need to transfer any data you might want to consider just hacking the mysqldump SQL code (good old Find & Replace...) to the point where SQL Server will execute it.
The easiest way could be:
I tried Microsoft SQL Server Migration Assistant v6.0 for MySQL which did most of the work for converting the schema and migrating the data from