Click here to Skip to main content
15,889,909 members
Please Sign up or sign in to vote.
1.00/5 (2 votes)
See more: , +
Dear All,
i want to develope such application on to that application i want to Use Two Databases(Oracal And SQL-Server) simultaniously.So Does Any one tell me how it is possible.

Thanks in advance....
Posted

1 solution

In my opinion the reliable way to do this is that you put the databases to communicate with each other, not so that you use the client application to do it.

For example in Sql Server you can establish a linked server[^] which can be a connection to another database including Oracle. Oracle has a same kind of mechanism: HS (Heterogenous Services).

Now on the server side you can use distributed transactions to handle multi database DML so that transactions are still reliable. Also you can for example manipulate the Oracle database from a trigger inside Sql Server database and so on.

Without any more specific information it's hard to say what you should do and how. But hopefully that gives the basic idea.
 
Share this answer
 
Comments
rahul walake 14-Sep-11 8:09am    
Sir,
We Want to develope Web Application on that at the time of installation (Configration in iis) application we give option to the end user like select the database(it may be Oracle ,Sql-Server,my-sql)then that time the selected database is intigrated with application. how it can be happen? give me any coding Guidline...


thanks in advance...

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900