Maintain Sync two Web Applications

Posted on 2007-07-26
Medium Priority
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
  • 2

Expert Comment

ID: 19586071
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

ID: 19586112
If they where both full SQL Server would there be a way?

Accepted Solution

Askeeto earned 2000 total points
ID: 19614815
With enterprise edition you could use peer to peer replication.

Featured Post

Prepare for your VMware VCP6-DCV exam.

Josh Coen and Jason Langer have prepared the latest edition of VCP study guide. Both authors have been working in the IT field for more than a decade, and both hold VMware certifications. This 163-page guide covers all 10 of the exam blueprint sections.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The viewer will learn how to use NetBeans IDE 8.0 for Windows to connect to a MySQL database. Open Services Panel: Create a new connection using New Connection Wizard: Create a test database called eetutorial: Create a new test tabel called ee…
The viewer will learn how to use and create new code templates in NetBeans IDE 8.0 for Windows.

864 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