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
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
;