Solved

Using SQL Server and Oracle Database in one project

Posted on 2011-03-02
2
334 Views
Last Modified: 2012-05-11
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 ?
0
Comment
Question by:pratz09
2 Comments
 
LVL 11

Accepted Solution

by:
jasonduan earned 500 total points
ID: 35021058
1. Don't "declare respective connection strings in global.asax file". You should put connection string in web.config file
2. in your code, you'll need use "System.Data.OleDb" instead of "System.Data.SqlClient" client so that both Oracle and Sql Server are supported
0
 

Author Closing Comment

by:pratz09
ID: 35027879
Doh ! I meant web.config .. My bad.
Thanks for your input. It was helpful.
0

Featured Post

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
This video shows how to Export data from an Oracle database using the Datapump Export Utility.  The corresponding Datapump Import utility is also discussed and demonstrated.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

749 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question