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,