title: How to achieve Blue Green deployment model in SQL Server databases?
body: <p>In our Organization, we are using SQL Server Standard edition 2008 R2.  Our database sizes are around 200-500 GB.</p>
  
  <p>To achieve zero downtime, we are planning to go with Blue Green deployment model.</p>
  
  <p>Looking forward with following problems.</p>
  
  <p>Schema changes in release deployments .
  Patch upgradation
  Data migrations
  Do we have any  readymade solutions with sql server on this? Like when release deployments have to happen on secondary server?</p>
  
  <p>Can we achieve this functionality with Always on in SQL server 2016 or SQL server 2008r2 Clustering?</p>
  
  <p>Thanks in advance!  Please provide your suggestions</p>
  
  <p>Regards,</p>
  
  <p>Muthu</p>