Click here to Skip to main content
Rate this: bad
Please Sign up or sign in to vote.
See more: C#2.0 C#3.0 C# C#4.0 , +
how to insert data after every 20 minutes , i am fetching data from oracle and saving in sql , oracle database will update every time i want to update sql data base as well ,. using windows form ..
Posted 18-Dec-12 23:21pm
Edited 18-Dec-12 23:33pm
CPallini at 19-Dec-12 4:46am
Please elaborate. Do you need to transfer data between databases?
Mohammed Abdul Muqeet at 19-Dec-12 4:53am
Yes i want to transfer data between databases using simple application
for every 15 or 20 min so that if any record inserted in oracle , and the application runs the record will add it to sql database.,
chester_it21 at 19-Dec-12 5:56am
Why you not try using schedule in OS for run your app...
Rate this: bad
Please Sign up or sign in to vote.

Solution 1

A timer will handle the 15 or 20 minute ... have a look at[^]
Rate this: bad
Please Sign up or sign in to vote.

Solution 2

You can create SSIS package for the same and schedule SSIS package to run as per your need.
In SSIS package create one task to read data from Oracle and with other task Save the fetched data into SQL server.
Hope this will help you.
Refer the below links for more information about SSIS.
Steps to Create your First SSIS Package[^][^][^]

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
0 OriginalGriff 685
1 Maciej Los 290
2 Richard Deeming 185
3 Suvendu Shekhar Giri 184
4 Abhinav S 166
0 Sergey Alexandrovich Kryukov 9,678
1 OriginalGriff 9,135
2 Peter Leow 5,082
3 Kornfeld Eliyahu Peter 3,373
4 Maciej Los 2,606

Advertise | Privacy | Mobile
Web03 | 2.8.150327.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100