title: How to generate a sql script to update existing database and retain its data
body: <p>I have a SQL Server 2008 database (call it productionDB) that contains data and will be used in a production environment.</p>
  
  <p>I have another SQL Server 2008 database (call it stagingDB) that is used in a staging environment.</p>
  
  <p>The application that I am working on continues to evolve such that I am often making changes to the database schema (namely adding/editing tables and adding/editing stored procedures).</p>
  
  <p>Up to this point, every time I have made changes to stagingDB I have generated scripts (via the SQL Server Scripts Wizard) that will drop/create all the schema. So, when I ran the scripts on the productionDB, it would successfully get updated to the updated schema, but all data that productionDB had would be lost - which has been fine, up til now.</p>
  
  <p>Moving forward, I would like to generate scripts that will keep the existing data in productionDB as well as update its schema.</p>
  
  <p>I cannot find an option(s) in the SQL Server Scripts Wizard that will do what I am describing.</p>
  
  <p>Is the SQL Server Scripts Wizard capable of doing what I am looking for? If so, how?</p>