Keeping 2 SQL Servers in Sync

Discussion in 'Databases' started by bctinsley, Jul 28, 2005.

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

    bctinsley

    What is the recommended method to keep a local copy of SQL Server tables and the hosted copy in sync? Occasionally there is a need to add/update stored procedures. All the updating and testing takes place inhouse and then when approved, these changes need to be reflected on the web. Is snapshot replication an option or is there one more compatible with dasp.net hosting?

    Brian
     
    bctinsley, Jul 28, 2005
    #1
  2. Bruce

    Bruce DiscountASP.NET Staff

    Replication is not supported because both servers need to be on the same windows domain.

    We use a 3rd party product to sync our dev and live DB, red gate SQL compare. http://www.red-gate.com/

    Bruce

    DiscountASP.NET
    www.DiscountASP.NET
     
    Bruce, Jul 28, 2005
    #2
  3. bctinsley

    bctinsley

    Thanks, bruce. Their products look interesting.


    brian
     
    bctinsley, Jul 28, 2005
    #3
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