Link to home
Start Free TrialLog in
Avatar of cscg1976
cscg1976

asked on

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

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?

Thanks
ASKER CERTIFIED SOLUTION
Avatar of DropZone
DropZone
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Ted Bouskill
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.