Currently, we use the PL SQL to connect and query the Oracle database. Software is built on .NET platform (VB, ASP). We have a implementation project in which we need to host our data set in the SQL server database too. May be completely or partially for some specific modules. Some modules might have to use data from both Oracle and SQL Server Databases.
My Question is : Please suggest a memory and cost efficient process to be able to do this. My idea about it is that we just need to declare respective connection strings in global.asax file and use them appropriately when needed. Right ? Or is there any catch to it ?