CODEWITHSUNDEEP
mysqlsql-serverrestore
Jack Marchetti
Jack Marchetti

Reputation: 15754

Restoring huge MySQL dump file to MS SQL Server 2008

I have a 19 GB .sql file which is a dump of a MySQL database.

How could I go about mounting that to MS SQL server? Is it just a matter of loading the 19 GB file into management studio and hitting F5?

I don't have access to the original MySQL databases or the server they were running on.

Thank you.

Upvotes: 0

Views: 1361

Answers (1)

Namphibian
Namphibian

Reputation: 12221

I would go about it like this.

  1. Restore the MySQL databases to a MySQL server.
  2. Setup a linked server from MS SQL to MySQL
  3. Do a SELECT * INTO destinationtable FROM linkedserver.dbo.sourcetable

The only problem here is that you will need to make sure that index definitions etc are recreated.

Youre MySQL backup file will not run in MSSQL without a LOT of work.

Upvotes: 2

Related Questions