This question already has an answer here:
Not too sure if this would be a good and proper way to go about things, so I apologize if I'm kind of far off.
Currently running Microsoft SQL Server 2005, and in this we have a database for a production website, and now just made a copy of it for a development version of the website. What my question is, what would be the proper way to "replicate" or "mirror" table structure changes and things of that nature from the development database to the production one, when we do our upgrade? Is there a simple way to do a migration like this?