I have two tables on an on premisses server that I'd like to have replicated in real time (not near real time).

After analyzing, the nearest thing I found was Azure Data Factory, which allows me to have a scheduled trigger which is near real time. What I'd like to achieve is really data that is in one place is also on the other place, no difference at all.

I could achieve this with distributed transactions when I was working with on premisses servers but since one of the is in the cloud, what else can I do to achieve realtime?

Thanks!