title: SQL Server 2005 - Syncing development/production databases
body: <p>I've got a rather large SQL Server 2005 database that is under constant development. Every so often, I either get a new developer or need to deploy wide-scale schema changes to the production server.</p>
  
  <p>My main concern is deploying schema + data updates to developer machines from the "master" development copy.</p>
  
  <p>Is there some built-in functionality or tools for publishing schema + data in such a fashion? I'd like it to take as little time as possible. Can it be done from within SSMS?</p>
  
  <p>Thanks in advance for your time</p>