Design Strategy: Query and Update Data in Two Different Databases

Question

We have a requirement in which we need to query data in two different databases (1 in SQL Server and others in Oracle).

Here are the scenarios that need to be implemented:

• Inquiry. Retrieve data from one database and match values ​​in others
• Update: retrieving data from one database and updating objects in others

Technology we use: ASP.net, C #

The options we were thinking about:

• Storage area in one database
• Link server (cannot go with the approach, because it is not allowed due to the general policy of the organization).
• Web Services Creation
• Create 2 different DALs and perform data operations from two sources in the DAL

, ? , .

Answer 1

SSIS ASP.Net, # , ?

Answer 2

, ?

, .

, ETL . , . ETL .

Answer 3

Microsoft SQL Oracle:

• https://web.archive.org/web/1/http://articles.techrepublic%2ecom%2ecom/5100-10878_11-1054237.html

, , , , , , :

• .
• .

Answer 4

Linked Server, , . , , - , , .

, , :

• , ( ), ,
• , , temp/dummy ( , )
• temp , .

, - , . , db, , LAN/ .

. . -

Answer 5

, . , .

RealTime:

WebServices, . WebService, . , , - .

(, ) , . .

, , . , , .

, WebServices.

Answer 6

.NET , , CRUD- ACID .

, @Will ...

, .

Answer 7

DAL - , , 100 000 , .

Use linq to perform data operations on datasets that are generated, not through them.