title: WordPress WooCommerce Staging Site Database Sync
body: <p>I manage a WordPress WooCommerce site which has a couple mishaps in the recent past. There is no staging environment setup which would have prevented the mishaps and is not trying to set one up. </p>
  
  <p>I have researched many WordPress DB Sync plugins, however, not many states they work well with WooCommerce. The issue is on my side, the product team can update <code>add/remove</code> products, categories, blog posts, etc. at any given time, they have no set time-frame window which updates the site.</p>
  
  <p>I need a way that I can sync menu structures, products, and all, blog posts, etc. with the production environment. I need to sync, because while the product team is working new orders come in and comments are posted, etc. </p>
  
  <p>Is there any easy way to set up a staging site that will accomplish this?</p>
  
  <p>Daily, I work with MSSQL and write a lot of SQL, so I thought I could write a sync script for <code>moving/syncing</code> data to production, however, the command I needed <code>"MERGE"</code> is not available in MySQL. Or, is there a way WordPress can run on MSSQL?</p>
  
  <p>Any ideas?</p>