• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 266
  • Last Modified:

Working with SQL Server and Oracle in C#

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
novknow
Asked:
novknow
1 Solution
 
daczCommented:
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
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now