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()
        private void button1_Click(objectsender, EventArgs e)
SqlConnection con = new SqlConnection("Data Source=(local);Initial Catalog=Mreport;Integrated Security=True;");
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"];




Posted on Dec 12, 2012 04:19 AM