OraFAQ Forum: Server Administration » Live Synchronization of data between ORACLE AND SQL SERVER

Home » RDBMS Server » Server Administration » Live Synchronization of data between ORACLE AND SQL SERVER

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Live Synchronization of data between ORACLE AND SQL SERVER [message #61530]

Mon, 03 May 2004 06:46

Navin
Messages: 31
Registered: May 2002

Member

Hi,

We want to synchronize data between Oracle and MS SQL Server. Whenever a table gets updated in Oracle, a corresponding table(s) should get updated in MS SQL Server and vice -versa.�

Synchronizing data nightly is what we have right now (using procedures). But now we want to sync. data whenever changes happen to any database and changes to be reflected in�other database.

Please let me know if you have any idea.

Thank you.

Rachna

Report message to a moderator

Re: Live Synchronization of data between ORACLE AND SQL SERVER [message #61575 is a reply to message #61530]

Wed, 05 May 2004 22:31

samhita bhattacharya
Messages: 3
Registered: May 2004

Junior Member

If you are using oracle 9i there is a tool transperant gateway from oracle by which you can always trnsfer the objects of oracle9i to sql server 7.0 or lower version

Report message to a moderator

Previous Topic:	Deallocating unused table space
Next Topic:	database hang when using LDAP

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 15 21:24:59 CDT 2025