Announcement

Announcement Module
Collapse
No announcement yet.

database link between mysql servers

Page Title Module
Move Remove Collapse
X
Conversation Detail Module
Collapse
  • Filter
  • Time
  • Show
Clear All
new posts

  • database link between mysql servers

    Hi,

    I know that is not possible to create a database link between mysql servers. Is there some function or trick to solve the problem without using federated engine.?

    Thanks for your help.

  • #2
    No, federated engine is what you use to query tables on a remote server as if they where local, if that was what you where referring to.

    Comment


    • #3
      Thanks for your answer.

      Comment


      • #4
        It is possible to link between MySQL server with MSSQL Server.
        Try read below link which is explain how to.
        http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_s erver_in_MS_SQL_Server?ID=6&article=6

        Comment


        • #5
          johan wrote on Sat, 25 December 2010 02:27
          It is possible to link between MySQL server with MSSQL Server.
          Try read below link which is explain how to.
          http://www.infi.nl/blog/view/id/4/How_To_MySQL_as_a_linked_s erver_in_MS_SQL_Server?ID=6&article=6
          Except that is not between two MySQL servers, that is between a MySQL server and a MSSQL server.
          And you can only get access to the MySQL databases in the MSSQL server and not the other way around.
          So even if you connect one MSSQL server to two MySQL servers you still would not have access to the other MySQL server from the first.

          Comment

          Working...
          X