Click here to Skip to main content
Rate this: bad
good
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
v2
Comments
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
good
Please Sign up or sign in to vote.

Solution 1

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

Solution 2

Hi,
 
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[^]
 
http://www.accelebrate.com/sql_training/ssis_tutorial.htm[^]
 
http://www.devart.com/dotconnect/mysql/docs/Tutorial_SSIS.html[^]
  Permalink  

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

  Print Answers RSS
0 Maciej Los 230
1 OriginalGriff 202
2 Richard MacCutchan 185
3 Tomas Takac 146
4 CPallini 125
0 OriginalGriff 5,130
1 DamithSL 4,237
2 Maciej Los 3,700
3 Kornfeld Eliyahu Peter 3,470
4 Sergey Alexandrovich Kryukov 2,846


Advertise | Privacy | Mobile
Web03 | 2.8.141216.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2014
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