Sync MSDE with MSSQL?

Discussion in 'Databases' started by rrhandle, Mar 9, 2005.

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

    rrhandle

    We have two web sites with DiscountASP (Live and Test), each has MSSQL database. Additionally, an application running in-house uses MSDE. Some of the tables in the MSSQL and MSDE databases are identical, and need to be kept in sync with each other. After reading through the forums, I have not found a good answer on how to do this. Could someone suggest the best way to do this? Or even A way to do it?

    Thank you
     
    rrhandle, Mar 9, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Keeping them 2 databases in sync is very tricky in this environment. It's much easier if you just want to overwrite one set of data with another (eg. Overwrite a set of table content from the MSDE to MSSQL every sunday night).

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Mar 10, 2005
    #2
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