Click here to Skip to main content
13,147,383 members (29,925 online)
Rate this:
Please Sign up or sign in to vote.
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 22:21pm
Updated 18-Dec-12 22:33pm
CPallini 19-Dec-12 4:46am
Please elaborate. Do you need to transfer data between databases?
Mohammed Abdul Muqeet 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 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
Top Experts
Last 24hrsThis month

Advertise | Privacy |
Web04 | 2.8.170915.1 | Last Updated 19 Dec 2012
Copyright © CodeProject, 1999-2017
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