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.

Question Title

* Which of these database scripts do you maintain? (select all that apply)

Static/config data scripts

A script to build the entire database

Migration scripts between specific database versions

Schema definition files (e.g. creation scripts)

None of the above

Question Title

* Do you save any of the above database scripts in source control?

Yes (please specify the source control system)

Question Title

* Do you have build automation (e.g. continuous integration) in place in your development environment that also involves keeping the database up to date?

No, we don't have build automation at all

We have build automation but this doesn't update the database

Yes, our build automation also updates the database

Describe any problems you have experienced with keeping your database up to date: