Home » SQL & PL/SQL » SQL & PL/SQL » 2 face commit on two diffirent databases
2 face commit on two diffirent databases [message #267321] Thu, 13 September 2007 00:58 Go to next message
annu-agi
Messages: 199
Registered: July 2005
Location: Karachi
Senior Member

hi experts,

I have two diffirent databases sql and oracle. i have already develope one application in oracle .. now i want that when i commit changes in one table, it would update the table in sql server simultaniously. is it possible ?? like same i want to make some quries on join bases of two table on different database plateform ..how can i do that??? any suggusion .. lets suppose if table emp i have on oracle .. but the other table like emp_salary_breakups is resides on sql server.. in this situation how can i join these tables .. ???that is a database end of work.

now In this regards when i worked on front end ... i found that VIsual basic can handle this situation easily rather then developer 2000 6i.. but i havent any expertise on it .. so if possible if any one can give me an example of VB coding regarding this matter would be more helpfull

any suggustions , any idea , articles ??? would be appriciatable .. pleas do help me ..

regards

Anwer
Re: 2 face commit on two diffirent databases [message #267325 is a reply to message #267321] Thu, 13 September 2007 01:03 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I don't know with SQL Server but with Oracle you have to use heterogenous service and create a database link between your Oracle database and your SQL Server one.

Regards
Michel
Re: 2 face commit on two diffirent databases [message #267343 is a reply to message #267325] Thu, 13 September 2007 01:30 Go to previous messageGo to next message
annu-agi
Messages: 199
Registered: July 2005
Location: Karachi
Senior Member

thanks michel

Give me a favour..?? Can you please tell me how to enable this heterogenous service ?? what is the complete procedure to make this service enable and create link between sql server to oracle server..

and tell me after that should i able to make queries like below

select a.code,b.name from xx1 a, xx2 b where a.code=b.code;
***where xx2 reside on sql server 



regards

anwer
Re: 2 face commit on two diffirent databases [message #267349 is a reply to message #267343] Thu, 13 September 2007 01:41 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Not a simple thing, can't be say in few lines.
Have a look at: http://www.oracle.com/pls/db102/print_hit_summary?search_string=heterogeneous+service+

Regards
Michel

Previous Topic: Calling Function
Next Topic: procedure
Goto Forum:
  


Current Time: Sat Dec 03 04:07:48 CST 2016

Total time taken to generate the page: 0.21112 seconds