Re: Database link to a MS SQL Server 2000

From: Bjarke Wedemeijer <bjarke_at_wedemeijer.dk>
Date: 10 Jun 2005 21:43:57 -0700
Message-ID: <6ac2a573.0506102043.44d6ae52@posting.google.com>

Do as Sybrand told you, look at the Heterogenous services of Oracle. Oracle even supports natively DRDA towards a DB2 z/OS mainframe, and they also support SQL Server. They all end-up like a database link with a totally quallified names in the "from" clause.

Be aware of that distributed joins between different DBMS systems might cause huge performance problems, keep the functionality when dealing with multiple DBMS systems simple, no distributed queries pulling data from several distinct DBMS systems.

//Bjarke Received on Fri Jun 10 2005 - 23:43:57 CDT