How to Fetch Data from Oracle Database and Save in SQL Server in C# .Net

Last Reply on Dec 12, 2012 04:19 AM By Mudassar

Posted on Dec 10, 2012 02:53 PM
  • i want to save records from oracle data to sql with timer with every 5 hours data should be fetch from oracle and save to sql,. there should be no duplication of ID number . 

    the data is huge around 100000 recrds in the table
     
    i am using this code for fetching data in text box 
     

     

 

public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }
 
        private void button1_Click(objectsender, EventArgs e)
        {
SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=Mreport;Integrated Security=True;");
con.Open();
SqlCommand sql = new SqlCommand("SELECT * FROM Transactions", con);
SqlDataAdapter objDA = new SqlDataAdapter(sql);
DataSet dsEmployee = new DataSet();
objDA.Fill(dsEmployee, "dtEmployee");
dataGridView1.DataSource = dsEmployee.Tables["dtEmployee"];

             conn.Close();
        }
 
      
    }
}