-
Hi gurus,
I have a procedure which pulls in a few million records from a remote database.
If at any point, my database is down or the remote db is down then this pull is interrupted.
Is there any way I can check for this and resume the pull automatically when the database is up again?(either mine or my remote source).
Thanks guys!
Hemant
-
I think the only way is to make your code smart enough to
know if some of the data has been pulled already.
You could pull the data at say, 1000 records at a time, inserting the rows into a local table. Then if you lose your connection, you can just pull the rows which have not been pulled yet....
-John
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|