none
Restore MySQL bakcup to SQL Server RRS feed

Answers

  • No, but   you can create a linked server to MySQL server and transfer the data into SQL Server
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Chirag Shah Thursday, October 28, 2010 8:12 PM
    • Marked as answer by Tom Li - MSFT Monday, November 1, 2010 7:32 AM
    Thursday, October 28, 2010 7:50 AM
    Moderator

All replies

  • No, but   you can create a linked server to MySQL server and transfer the data into SQL Server
    Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/
    • Proposed as answer by Chirag Shah Thursday, October 28, 2010 8:12 PM
    • Marked as answer by Tom Li - MSFT Monday, November 1, 2010 7:32 AM
    Thursday, October 28, 2010 7:50 AM
    Moderator
  • Thanks Uri,

     

    I installed MySQL database on my machine, created a new empty database, restored the backup from the mysql dump (.sql) file.

    command: mysql -u username -p password dbname < c:\dumpfile.sql

     

    Installed ODBC client from same mysql site where I downloaded the DB.

    Created a System DSN via the ODBC connector and finally created a linked server for that DSN.

     

    Now I can easily query my MySQL database, store the result in temp tables and query with more power of MS SQL engine.


    ~Manoj

    http://sqlwithmanoj.com/


    Tuesday, November 2, 2010 11:20 AM