title: use c# to copy table data from oracle to SQL Server?
body: <p>Could you kindly tell me whether there is a most convenient way to  copy table data from oracle to SQL Server?</p>
  
  <p>My only idea is iterate all rows and do insert operation. That means i should write lots of code.</p>
  
  <p>I want to know may I use <code>DataSet/DataAdapter</code> or other convenient C# methods to do migration? </p>
  
  <p>PS. under C#/.NET2.0 env.</p>
  
  <p>Thanks indeed.</p>