CODEWITHSUNDEEP
mysqlsql-serverdatabase
Mike L
Mike L

Reputation: 4913

Import MySQL MyISAM into SQL Server

Caveat: I have zero experience with MySQL.

I've been given a series of files to do a data conversion and would like to migrate the provided data into SQL Server 2008. The files are:

These file types, as I understand it, are MyISAM. I believe that if I had a running MySQL instance, migrating to SQL Server would be fairly straightforward. I could could either use SQL Server's import wizard or Microsoft SQL Server Migration Assistant for MySQL v1.0. Unfortunately, these files are what I'm stuck with -- I just don't have access to the original MySQL instance.

I also don't presently have MySQL as a running instance locally and I'm not sure if there would be compatibility issues with the files I have.

Can I attach them to MySQL 5.5 with the goal of performing a SQLDump or perhaps to use either tool mentioned above? Am I missing a better way?

Upvotes: 0

Views: 2069

Answers (1)

a1ex07
a1ex07

Reputation: 37382

Yes, you can easily attach them to MySQL 5.5. Then you can dump the tables using mysqldump (be aware that you will need to either modify dump and remove mysql-specific stuff from the dump, or probably customize mysqldump output - check mysqldump documentation for details). You can also try to link Mysql instance to SQL Server, and then copy tables using SELECT ... INTO [sql_server_table_name] FROM [mysql_table_name]. In any case, the hardest part is to migrate stored procedures/triggers. Mysql and SQL Server have quite a different syntax for them, so you probably cannot automate this process.
Update
Also, I forgot to mention that you will have to modify mysql auto_increment columns to IDENTITY([next_auto_increment_value],1) SQL server.

Upvotes: 1

Related Questions