Re: Is there an equivalent to MS SQL "Linked Server"
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
Subject
Written By
Posted
Re: Is there an equivalent to MS SQL "Linked Server"
May 20, 2005 09:12AM
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.