title: How do I publish SQL Server Database to Azure to update existing database
body: <p>I publish my SQL Server database on my local machine to Azure via Management Studio. </p>
  
  <p>Say I name the database on Azure "California". The first time I do it its ok. </p>
  
  <p>Then I made changes on my database on local, adding columns, adding data, etc. Then I want to deploy this database to Azure again. </p>
  
  <p>But now Management Studio won't let me do it. It says database "California" already exists on Azure. </p>
  
  <p>I can get away with this problem by deleting existing "California" on Azure first, then deploy again. But this seems not correct...Every time I make database changes on local, I need to delete the one on Azure before I deploy?</p>
  
  <p>Does anyone know how to solve this problem?</p>