Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Working with SQL Server and Oracle in C#

Posted on 2007-03-18
2
Medium Priority
?
255 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 2000 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
When trying to connect from SSMS v17.x to a SQL Server Integration Services 2016 instance or previous version, you get the error “Connecting to the Integration Services service on the computer failed with the following error: 'The specified service …
Via a live example, show how to take different types of Oracle backups using RMAN.
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.

618 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