MySQL Forums
Forum List  »  Newbie

Re: Is there an equivalent to MS SQL "Linked Server"
Posted by: Travis Rushton
Date: May 20, 2005 09:12AM

Hi Felix,

I use MS Sql Server Enterprise Manager (GUI interface) to LINK to any number of database structures... Oracle, Progress, MySql, etc. I can then issue queries by simply referencing the "Linked Server"name.owner.tablename for instance to look up serialnumbers from an oracle serial number database on another physical server I can issue

SELECT SerialNumber, Model FROM TWACS..DCSI.SERIALNUMBER

Where
TWACS = the linked servername
DCSI = db Owner
SERIALNUMBER = tablename

It makes for a great way to use a single development environment to access and bring together all sorts of data.

Lemme know if you have any ideas. The thought of using MySQL is interesting but I need the flexibility shown above so as not to be LOCKED to any one environment.

Travis

PS: Also, is there a BEST tool for graphically adminsitering and programming in MySQL

Options: ReplyQuote




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.