We have a system to hold employee information that uses a MySQL database for this in each network. Now here is the thing:
1.- The Human Resources Department is in one building.
2.- Employee information is in two separate buildings, but some people can go from one building to another, and they can be changing their personal information in any of the two buildings.
3.- We have managers who are in both buildings, and they would like to see the employee information no matter in which building they are on.
- How could I keep the two databases synchronized correctly?
- Is there a FREE tool out there to accomplish this (My boss doesn't want to spend money on any tool
- Any PHP script to do this?
Don't worry about user names and passwords, that issue has been solved using active directory in each network (Yes, we have two different usernames and passwords for both buildings).
Any ideas on how to do this??
Many thanks!