QUESTION:
We are looking to migrate from a Microsoft Access database to MySQL
for our CRM application.
However one of our requirements is the ability to synchronize partial
replicas - both from a laptop on a LAN and also from a remote location
e.g. a branch over an internet server.
Our current solution handles the situation fine but falls down when
attempting to do a partial replica synchronisation over an internet
server.
The application is a CRM system (Customer Relationship Management)
with one central server at head office and several subsets of the
database sitting on sales reps notebooks. Eg the HO server database
contains all the customer data but each sales rep only has their own
customers and related data on the laptop. It is critical, that we can
give a sales person on his laptop only his section of the customers -
not the entire CRM database. The reps would need to synchronise their
laptops on the LAN.