Results 1 to 3 of 3

Thread: Import Data

  1. #1
    Join Date
    Jul 2005

    Angry Unanswered: Import Data

    Hi everybody,
    I want to import data from different server.

    According to my system. when we sell anything to our customer we upload all the information to webserver from our local server. This job we are doing it manually right now. but i want to upload the information automatically. when my agents sell something and they submit as sell i want to send a copy of information to my webserver automatically. Is there any trigger which can insert data into different server or schedule which can import data from different server. Please help me

  2. #2
    Join Date
    Jun 2003
    read BOL about trigger,if u want immediate update to ur webserver.
    Or u can write procedures and schedule it,check BOL schedule job.
    I love cursor,though I never use it.Cos' I dont want to misuse it.


  3. #3
    Join Date
    Jun 2003
    Provided Answers: 1
    I try to steer clear of triggers which operate outside the scope of the database. Consider using the trigger to populate a staging table of changes, and then running a scheduled job to load those changes to your destination database. This setup is more tolerant of system disruptions.
    If it's not practically useful, then it's practically useless.

    blindman "sqlblindman"

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts