title: One-way sync between MySQL and SQL Server
body: <p>I have a table A on MySQL and a table B on SQL Server.</p>
  
  <p>Now, I need to keep B in sync with A (one-way), but B should "always" remain accessible for querying (now, one second of downtime won't hurt anyone...). The sync should occur once every hour.</p>
  
  <p>Some scenarios come to mind:</p>
  
  <ul>
  <li>Check A for updated/inserted/deleted rows, then update these in B (might get complicated);</li>
  <li>Truncate B, then fill it again with data from A (might take a while and lock B);</li>
  <li>Fill C with data from A, then drop B and rename C to B (seems dirty);</li>
  <li>...</li>
  </ul>
  
  <p>What to do?</p>
  
  <p>For reference: The first solution I tried, was making B a view, using OPENQUERY to show A's data, but performance wasn't great.</p>
  
  <p>There are probably some commercial products that can do exactly this, but I would just like to do this in a SQL Server job.</p>