title: Copy data from on premisses SQL to Azure SQL in real time
body: <p>I have two tables on an on premisses server that I'd like to have replicated in real time (not near real time).</p>
  <p>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.</p>
  <p>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?</p>
  <p>Thanks!</p>