Keep MS SQL data update

Discussion in 'Databases' started by baldridge, Jan 17, 2006.

Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.
  1. baldridge

    baldridge

    Hello all, I'm trying to find a method to keep my MS SQL database updated on my discountasp.net site from a MS SQL database on our domain. Does anyone know way to do this? I have read through the forum and know that MS SQL DTS and replication are not an option.This would be a good FAQ.

    Any help, tutorials, examples or software solutions would be great!
     
    baldridge, Jan 17, 2006
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    schedule a DTS package to run on your local SQL server that push the data to the hosted SQL server.

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jan 19, 2006
    #2
  3. baldridge

    baldridge

    Cool, I got that to work with a basic DTS export such as dropping the table and recreating the table from my local table. I can even schedule it per hour if necessary. I tried doing aDTS with an update but got an error that the remote(hosted SQL) might not allow the action. Is that true? do you allow updates? If so can you show an example update statement where one column is updated based on a change in the same local column?
     
    baldridge, Jan 19, 2006
    #3
  4. JorgeR

    JorgeR DiscountASP.NET Staff

    gogetsome

    What is the exact error that you received"...(hosted SQL) might not allow the action" as DASP does allow for updates . Try settingup triggers on the column


    junior

    DiscountASP.NET

    www.DiscountASP.NET
     
    JorgeR, Jan 20, 2006
    #4
Thread Status:
Threads that have been inactive for 5 years or longer are closed to further replies. Please start a new thread.

Share This Page