There are two databases in different locations.one in my local database server and the other in a remote server. I want to synchronize theses two databases so that the data available in both servers are exactly the same .when ever any dml operation takes place on one server then the other should also be replicated .What are the bottlenecks and the step by step procedure of implementation.

Thanks for ur reply. How do I Install MySql.Data.dll in gac. When I tried using gacutil -i MySql.Data.dll, got an error "Attempt to install an assembly without a strong name"

I have developed a windows service in C#, however, when I start the service. I get the error detailed below. Can anyone help solve this problem? Could not load file or assembly 'MySql.Data, Version=1.0.7.30072' or one of its dependencies. The system cannot find the file specified.