I have been tasked with finding a method of synchronizing offsite branches to the HQ.
It will be one-way synchronization of certain tables from the remote branches databases to the HQ database. The databases from the remote sites and HQ have the same schema.
The data will require to be synchronized every minute and the data size is less than 100KB.
Ideally what should only be synchronized are the differentials (new data in the specified tables).
Finally the branches and the HQ are running Server 2008 R2 Express.
My questions are:
Can this be achieved with the Express edition?
If not, will I have to implement some powershell, export, import thing? (Guessing here)
What type of replication would it be best suited for this?
Or are there any 3rd party utilities out there than can achieve the required result?