C# sample code for copying a table from oracle to ms sql with ODP.NET needed

0 pts.
Tags:
C
Oracle
SQL
I want to copy a table from an oracle database to a sql server using the odp.net provider. Because I just have the .NET Framework SDK and the Eclipse C#-PlugIn it is very difficult for me to figure out how I can code this in detail. I successfully read from an oracle table with a datareader object but for copying a table I think I need to have a DataAdapter and a DataSet. What I want to have in the end is a small command line tool which takes a table name as a parameter and then copies the table and all entries from the oracle server to the ms sql server. I think it can be done in 10 lines of code, maybe someone can give me a working example... Thanks for your help, Mark
ASKED: October 19, 2004  9:01 AM
UPDATED: October 21, 2004  1:24 AM

Answer Wiki

Thanks. We'll let you know when a new response is added.

I found a solution now:
The way to go is as I thought to use a OracleDataAdapter, then filling a DataSet und using this DataSet to Update a SQLAdapter. But this only works if you set the property AcceptChangesDuringFill = false from the OracleDataAdapter !!

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following