Sql Express 2005 Synchronization --> Asp.net 2.0 Framework

Posted on 2007-08-04
Medium Priority
Last Modified: 2013-11-07
I have to develop a web application and I have the following questions:

Technology thinking of using
ASP.net Framework 2.0
MSSql express edition 2005

In the architecture design we decided to go with an offline approach. Meaning that we are going to have a server with an IIS at the Local Offices and one remote server in a web hosting  environment. Both Server are going to have MSSql Server Express Edition 2005 and are going to get synchronize with each other. So the user can choose either to work with the remote server or the local server.

1.My question is whether you have some ideas of how to synchronize the 2 sql express servers and how to use the locking of certain records in order to do that.
2.Is it better to go with PHP aand Mysql technology?
3.How can I connect a remote server with the local server. What do i need ? What do i need to ask the Web Hosting Provider in order to be able to connect to the remote sql express server and syncrhonize it with my local server?

Question by:cscg1976
LVL 18

Accepted Solution

DropZone earned 1500 total points
ID: 19630723
We have this sort of set up in our office, albeit with MS SQL Server 2000:  We have a web server with its own database server out on the DMZ which synchronizes with the internal database server.

We synchronize using custom replication process, but the SQL Server replication service should work well (our problem is that due to braindead firewall policies, replication is blocked from communicating between both servers).

If you need to create your custom replication solution, then you can follow our approach.  Its simple, if somewhat convoluted (I did not design it!):  All tables have an extra bit column flagging them as modified.  Triggers set these flags.  We also have a separate table marking which tables have been updated.  Our replication application periodically checks these flags and syncronizes both ways as necessary, taking into account any conflicts (e.g. the same record was modified on both sides).  You can build this as complex as you need.

LVL 51

Expert Comment

by:Ted Bouskill
ID: 19631564
If it is a thin-client solution why can't the local office connect to the web front end at the hosting site?

Replicating databases (mirroring) creates risk and complexity that is often not worth the trouble.

MySQL is NOT a enterprise solution.   I wouldn't recommend it if you require replication.

Featured Post

Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

Question has a verified solution.

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

A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This article shows how to deploy dynamic backgrounds to computers depending on the aspect ratio of display
this video summaries big data hadoop online training demo (http://onlineitguru.com/big-data-hadoop-online-training-placement.html) , and covers basics in big data hadoop .
Are you ready to place your question in front of subject-matter experts for more timely responses? With the release of Priority Question, Premium Members, Team Accounts and Qualified Experts can now identify the emergent level of their issue, signal…

809 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