MySQL Forums
Forum List  »  General

Access data from a schema lying on a different server
Posted by: My SQL
Date: November 03, 2010 03:30AM

Hi all,

We are moving some of the schema to a different physical server due to size issue.

Since some of the current queries include joins from different schema which now happen to be on different servers, is it possible to keep the join active by calling the other schema on a different physical server?

For example in SQL you can use the ADO SQL Recordset.

Please let me know hot access data from a schema lying on a different server?

Thank you,

MYSQL_User

Options: ReplyQuote


Subject
Written By
Posted
Access data from a schema lying on a different server
November 03, 2010 03:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.