Home » RDBMS Server » Server Administration » Live Synchronization of data between ORACLE AND SQL SERVER
Live Synchronization of data between ORACLE AND SQL SERVER [message #61530] Mon, 03 May 2004 06:46 Go to next message
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 Go to previous message
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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri May 09 13:39:12 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.