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.