synchronizing data updates between Oracle and SQL server

[dustind]

Hi!
I am dusty,,,
I think I might have an unique query..

1, Can we synchronize data updates between Oracle and SQL server- parallel?
Updates at the same time and must reflect at both the DB's..
If so how to do it ...is there a tool for it or should it be done in the front end coding.. My client has his data’s on both the DB's

2, Is there a way to access SQL server through oracle table level triggers and vice versa? as far As I know it cannot be done ....is there anyone who can answer the same

This is needed very urgently
Dusty

[aspdba]

Its possible to connect to oracle db and make changes from sql server through linked server.

[dustind]

I know the connectivity from sql server to oracle .. I want reverse compatibilty

[Srinivas_Sharma]

hello

u need to go for heterogenous connectivity option.

you can connect to sql server using the above connectivity.

check out for the documentation...

http://otn.oracle.com/products/oracl...y_rel2_ds.html

this thread might be useful for u

http://dbforums.com/arch/50/2002/12/633671

HTH

SS

[aspdba]

can use oracle 9i transparent gateway for sql server...but aint free I suppose!!

[DaPi]

The gateway products are not free - you would need this http://www.oracle.com/gateways/gatew....html?faq.html at $15K.

A poor-man's solution is to have a PC that pumps data between the two servers using ODBC - but I guess you could easily spend $15K making that work

[dustind]

Srinivas thanks for the reply and it was helpful .. The only problem is that is it useful for inserts and updates. I will try it real time and see. But from what I see in the example it is useful for only querying the sqlserver. I Want parallel updates from oracle

[Srinivas_Sharma]

thats ok

let me know if u have tested and implemented it.


SS

[dustind]

Thanks Srinivas HSodbc in oracle does the job beautifully