Yes you can do it in oracle too and it works in both directions. In fact you can even do the link with non-oracle databases.
********* Use the CREATE DATABASE LINK statement to create a database link. A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database system. However, to access non-Oracle systems you must use Oracle Heterogeneous Services. Once you have created a database link, you can use it to refer to tables and views on the other database. In SQL statements, you can refer to a table or view on the other database by appending @dblink to the table or view name. You can query a table or view on the other database with the SELECT statement. You can also access remote tables and views using any INSERT, UPDATE, DELETE, or LOCK TABLE statement. ************* brad -----Original Message----- From: C. Hatton Humphrey [mailto:chumph...@gmail.com] Sent: Friday, January 16, 2009 9:25 AM To: cf-talk Subject: Re: join two databases > You need to link your SQL Server instances. Google "SQL Server > Linked". > > You can link the servers both directions, if needed. > > With the server linked in SQL, you can create cross-server queries in > the Query Analyzer/New Query editor. Well would ya look at that! Learn something new every day, thanks for the education! Hatton ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;207172674;29440083;f Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:318070 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
