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?
By default, root@localhost has no password
Once mysqld.exe appears in the Taks Manager's process list, run the following
Database will be loaded in MySQL
You can check everything afterwards. First, login to mysql
Then run these client commands
You can set up DTS or any other mechanism for migrating from MySQL to SQL Server