Solved

Working with SQL Server and Oracle in C#

Posted on 2007-03-18
2
252 Views
Last Modified: 2013-12-19
Is it possible to do this:
INSERT INTO <OracleDatabase.TableA> SELECT * FROM <SQLServerDatabase.TableA>

I mean to populate a same table in Oracle by rerieving first from the SQL Server using C#?

0
Comment
Question by:novknow
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 1

Expert Comment

by:dacz
ID: 18746165
1 . create a stored procedure in SQL Server
2.  create a recordset and  populate it.
3.  connect to oracle database then insert the recordset to the oracle table.
0
 
LVL 143

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 18746364
if you can create a linked server to Oracle on your sql server, then you can do that on sql server:

insert into linked_oracle_server..schema_name.table_name ( <column names> )
select ( <column names> ) from your_sql_table
0

Featured Post

How Do You Stack Up Against Your Peers?

With today’s modern enterprise so dependent on digital infrastructures, the impact of major incidents has increased dramatically. Grab the report now to gain insight into how your organization ranks against your peers and learn best-in-class strategies to resolve incidents.

Question has a verified solution.

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

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
The article shows the basic steps of integrating an HTML theme template into an ASP.NET MVC project
This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not 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.

707 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