Last post Dec 12, 2012 06:43 AM by Decker Dong - MSFT
Dec 10, 2012 04:36 PM|Abdul Muqeet|LINK
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
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();
dataGridView1.DataSource = dsEmployee.Tables["dtEmployee"];
Dec 11, 2012 05:56 AM|aaa_78600|LINK
Dec 12, 2012 06:43 AM|Decker Dong - MSFT|LINK
Since you have so many records. To upload such a many record inside your table is almost impossible Because you need on-time update……as far as I see, I think you can：Use Windows Service instead of Web because this is an long period of time to do
the certain task. So windows service is more suitable for you.