I have a Web application that access to (reading or
modifying) a database.
I want to duplicate my Web server and database, in
order to put it in another network platform over the
Internet. For example, one is located in Paris and
the other in Brest (another town in west of France).
People who want to access to my application will
choose the Web server that is nearest from their place.
My problem is that i want to ensure the total coherence
of the two databases : if one of the database is
modified by a client, the same modification should
be immediatly made to the other database.
Can i do this with MS-SQL and how ?
Does distributed transaction answer to my problem ?
Or is there a way to do this without modifying the code
of my application ?
A hope someone anderstand my problem. Thank you very
much for answering...