DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Connectivity Loss during data retreival

  1. #1
    Join Date
    May 2001
    Location
    Atlanta US
    Posts
    262
    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

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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
  •  


Click Here to Expand Forum to Full Width