C# sample code for copying a table from oracle to ms sql with ODP.NET needed
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
Software/Hardware used:
Software/Hardware used:
ASKED:
October 19, 2004 9:01 AM
UPDATED:
October 21, 2004 1:24 AM
Answer Wiki:
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 !!
To see all answers submitted to the Answer Wiki: View Answer History.
RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
