Managing Database Migrations

 
Migrating from one version of a database to another has always been tricky. Schema comparison tools are helpful, but they fall short where it comes to managing the discrete database versions and the corresponding migration scripts to move from one version to another.

This survey aims to collate requirements, feedback and ideas, with the aim to improve the management of migrations for SQL Server.

Which of these database scripts do you maintain? (select all that apply)
Do you save any of the above database scripts in source control?
Do you have build automation (e.g. continuous integration) in place in your development environment that also involves keeping the database up to date?