I have the following scenario:
- I have build abig management database at our HQ and it is to be fed from several databases spread across regions.
2.I only want to have records of specific tables from those distributed databases be sent to my central database.Changes in Those tables should also be effected in the central DB.
The syncronisation/replication process should be scheduled and work automatically.
The purpose of the central DB at the Head-Quarter(HQ) is for detailed analysis and decision making purposes. That is why I want a tool that can graphically allow an administrator to select and connect to a remote table and schedule it to replicate its data to the HQ table.
Kindly advise a tool that has such features.