We have a small branch app that stores some data in a SQL Express Database.
We want to have an almost real time copy of this table in our headquarters, were we have SQL Enterprise 2014. I say almost, because it doesn't matter if there is a 5 minute delay or something like that.
The main thing is that it's able to synchronise after a network disconnection between branch and headquarter.
Any solution that does not requiere licensing costs for the branch office?
SQL 2014 Express does actually support transactional replication, but only as the subscriber, so that's not going to work here.
Does the table have a built-in
last_modify_date field that is reliably updated by the application when it inserts/updates rows?
If so, I would just write a custom job (maybe an SSIS package in a scheduled job on the headquarters server) that checks for changed rows and updates/creates the corresponding rows in the headquarters copy.
If the vendor application doesn't do that, then you'd have to do one of two things:
modifydatefield, and use the above functionality