实施多个数据库 [英] IMPLIMENTING Multiple Database

问题描述

亲爱的所有人，
我想在该应用程序上开发这样的应用程序，我想同时使用两个数据库(Oracal和SQL-Server).所以有人告诉我这是怎么可能的.

在此先感谢....

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....

推荐答案

在我看来，执行此操作的可靠方法是使数据库彼此通信，而不是让您使用客户端应用程序执行此操作.

例如，在Sql Server中，您可以建立链接的服务器 [

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.

这篇关于实施多个数据库的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！