Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

I have a MySQL file (apple.sql) that I need to restore to a SQL server 2008 database or at least be able to access the database through mySQL. I have created a linked server mySQL, created an empty database on mySQL. I am not sure how to restore the backup file (apple.sql) to the empty database?? Any ideas?

share|improve this question
    
Microsoft has a free tool that will help you: microsoft.com/sqlserver/en/us/product-info/migration-tool.aspx –  Max Vernon Oct 24 '12 at 15:05

1 Answer 1

You should download and install MySQL MSI on the Windows machine

By default, root@localhost has no password

Once mysqld.exe appears in the Taks Manager's process list, run the following

C:\> net start mysql
C:\> mysql -uroot -e"CREATE DATABASE apple"
C:\> mysql -uroot -Dapple < apple.sql

Database will be loaded in MySQL

You can check everything afterwards. First, login to mysql

C:\> mysql -uroot

Then run these client commands

mysql> use apple
mysql> show tables

You can set up DTS or any other mechanism for migrating from MySQL to SQL Server

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.