Sql Express 2005 Synchronization --> 2.0 Framework

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

Technology thinking of using 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

    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

    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

    Maximize Your Threat Intelligence Reporting

    Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

    Join & Write a Comment

    Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
    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…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
    This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor ( If you're looking for how to monitor bandwidth using netflow or packet s…

    746 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

    20 Experts available now in Live!

    Get 1:1 Help Now