Home » Server Options » Replication » URGENT!Please help .
URGENT!Please help . [message #75615] Mon, 07 February 2005 05:01
Shamitha Upadhaya
Messages: 1
Registered: February 2005
Junior Member
I have a requirement in which I need to link SQL server and Oracle table.Oracle table contains a subset of columns and data in SQL server database, but Oracle Db might contain latest data of existing records.In other words, Oracle DB is latest,but might not contain all required records.Oracle and SQL DB are never in-sync.

So, from front end, based on emp-id (which is a common field in Oracle and SQL server), I need to first lookup in Oracle Db and only if I did not find record in Oracle DB ,I have to check for the record in SQL server DB.How can we implement this?

Can we create a DB link between Oracle and SQL server DB? Is this advisable ?
How to massage data from SQL server ? using SPs or 3rd party EAIs?
Can we create a view and implement in the view itself the condition to include all records from Oracle Db and rest records from SQL server, (all records from Oracle Db union all (all records from SQL server minus records from Oracle DB))?

Please let me know
Previous Topic: deleted repgroup but it is showing in DBA_REPOBJECT.URGENT PL.
Next Topic: Oracle 9i - synchronizing 2 identical schemas
Goto Forum:
  


Current Time: Thu Mar 28 03:42:41 CDT 2024