Connect from MySQL instance to SQLServer

(3 posts) (2 voices)

Tags:

No tags yet.

  1. haigda, Member

    I have been asked to see if I can use the MyDBR instance we have on a cloud based MySQL server to read data from a similar cloud based SQLServer (both on AWS) To make thi9ngs more interesting I have only Read Only rights to the new server. Can this be done and if so how?

    Cheers,
    David

  2. myDBR Team, Key Master

    There is no easy solution for connect from MySQL to SQL Server. MariaDB has CONNECT storage engine which allows remote database objects to be mapped into local ones. Connecting from SQL Server to MySQL can be done using the SQL Server's Linked Server functionality.

    --
    myDBR Team

  3. haigda, Member

    Thanks once again for the prompt reply - I will investigate over the weekend

    Cheers,
    David


Reply

You must log in to post.