title: Copy Database Data on Azure into Another Database on Azure
body: <p>We have two sql databases, test and production, hosted on Microsoft Azure. Both databases have the same schema. Is there an automated or one-click way to copy all of the data from the production database into the test database. Whenever we make a new feature we want to be able to test it with up-to-date production data without testing it on the production database.</p>
  
  <p>Any amount of initial setup is fine, but ideally the end result would be to essentially hit a button and the copy is done.</p>
  
  <p>It is OK if the test database needs to be wiped beforehand.</p>
  
  <p>If there is no way to do this on Azure, what would the next best option be to get this result?</p>