Solved

Using SQL Server and Oracle Database in one project

Posted on 2011-03-02
2
303 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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

Suggested Solutions

Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and theā€¦
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
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.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.

747 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now