Last post Jul 20, 2010 10:17 AM by anujtripathi
Jul 19, 2010 11:28 AM|Ashutosh Bhardwaj|LINK
We have a requirement in which we need to query data across 2 different databases ( 1 in SQL Server and other in Oracle).
Here are the scenarios which need to be implemented:
Technology that we are using: ASP.net, C#
The options that we have thought about:
I would like to know what is the best design strategy to deal with this kind of a scenario
Jul 19, 2010 11:07 PM|sansan|LINK
I'm not sure about the kind of requirement that you have and the data retrieval process.
But, in you case going through web services is better it seems,
You can have only one Database independent DAL and web services to do the task for you.
correct me if I got it wrong.
Jul 20, 2010 10:17 AM|anujtripathi|LINK
My first expression to your requirement is this that It is really going to be time consuming and both as a web developer & user, I'll never recommend you to go for that solution which consume time. I really appreciate the options that you have proposed and
they all will work.
If I have to choose any one of them then I'll go for web services which run asynchronously. I am not sure about how many user can do this activity, if there are more than one user than it's going to be a conflict issue to.
Another option that you have only mentioned is "Staging area in one database", you can get the changed from the oracle database and update it to the staging server [Sql Server] and then synchronize it with Sync framework. Sync framework is cool, light and
very powerful, thanks to Microsoft.
But remmeber, never try to keep the data from any table into your application and then compare, in this case I afraid that you will lose performance of the applicatio.
I hope my reply will be useful for you.