pratz09
asked on
Using SQL Server and Oracle Database in one project
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 ?
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 ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for your input. It was helpful.