Maintain Sync two Web Applications

Posted on 2007-07-26
Last Modified: 2013-11-07
What I want to do is run two websites and keep them synced.

Each web site is on a different server, one web site will have a SQL Express Db and the other will have a SQL Server 2005 DB.

I would like to be able to read and write to each system.

If someone makes a job in System A it will also make it in System B.
If someone makes a job in System B it will also make it in System A.

Any ideas on a efficient quick way to approach this.

This is .NET 2.0
SQL Server 2005
Severs are in different Data-Centers so the connection is limited, I was thinking a web-service.

Question by:EazyWorks
    LVL 3

    Expert Comment

    Sql Server Express only supports replication subscription. (This means you can replicate your sql 2005 to the sql express, but not the other way around.)

    So if you want to keep everything in sync you will have to do "manual" replication which means send the updates to your databases to both servers and make sure you program a system to deal with conflicts.  

    Author Comment

    If they where both full SQL Server would there be a way?
    LVL 3

    Accepted Solution

    With enterprise edition you could use peer to peer replication.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
    THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now