DbUp is a set of .NET libraries that helps you to deploy changes to different databases like SQL Server. It tracks which SQL scripts have been run already, and runs the change scripts that are needed to get your database up to date.
To learn more about DbUp check out the documentation.
| Package | Stable | Prerelease | Issues |
|---|---|---|---|
| Documentation | |||
| DbUp-Core |   |
 |
 |
| DbUp-SqlServer |   |
 |
 |
| DbUp-MySql |   |
 |
 |
| DbUp-SQLite |   |
 |
 |
| DbUp-SQLite-Mono |   |
 |
|
| DbUp-SqlCe |   |
 |
 |
| DbUp-PostgreSQL |   |
 |
 |
| DbUp-Firebird |   |
 |
 |
| DbUp-Oracle |   |
 |
 |
For successfull unit testing install
- SQL Server Compact 4.0 SP1 https://www.microsoft.com/en-us/download/details.aspx?id=30709
Mainteannce and support for the extenstions where not provided by the DbUp project. If you have questions to the extions, please ask the author of the extenstion.
https://github.com/fiscaltec/DbUpX
Extensions to DbUp supporting easy filtering, ordering and versioning:
- a journaling system that stores hashes of script contents, so we know if they need to rerun,
- a concept of "dependency comments" in scripts that let you more easily control the ordering of scripts,
- protection against code reorganisation affecting long script names,
- utilities for sorting and filtering scripts in helpful ways.
The delimiter in a multi statement script should be on a new-line. I.e:
ALTER TABLE "MyTable" ADD "foo" int default null
;
ALTER TABLE "MyTable" ADD "bar" int default null
;