Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: accessing one database from another
In article <794mum$5ts$1_at_nnrp1.dejanews.com>, browns_99_at_hotmail.com
writes
>I was wonder if there is a way to have SQL Server connect to another database
>and pull a table from that other database (Oracle or DB2). This way I would
>only need to look at one database for all my data.
>
>Thanks in advance
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Don't know if it works with sql server but you can create database links
between Oracle databases - check the documentation for full details
--
Diane
Received on Tue Feb 02 1999 - 13:11:52 CST