Re: two databases - foreign views

#1

On 4 Aug 2003 23:11:45 -0700, zorkadi (AT) yahoo (DOT) com (Zork Adi) wrote:

Quote:

hi guys,

i have two databases, an informix and a sql server running in two
different machines. is it possible to have some of the tables from
informix as views in sqlserver and vise versa, so that when i insert
in the view data gets transferred to the other machine and inserted
there? i don't want to replicate any data. is there any commercial
product that can do this?

You can probably create views like this using ODBC or OLEDB links on
the SQLServer side (don't know about Informix, though). Whether or not
they would be updatable is another story; I would tend to say,
probably not.

What you might be able to do is to create triggers on the views which
handle the actual updates/inserts/deletes by operating directly on the
tables (so-called "instead-of" triggers).

--
Bob Hairgrove
rhairgroveNoSpam (AT) Pleasebigfoot (DOT) com

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: two databases - foreign views

comp.databases comp.databases

Re: two databases - foreign views - 08-06-2003 , 03:46 PM