DbUp Package Manager Console Scripts

Package Manager Console scripts for DbUp.

Install

This package is hosted on NuGet.

Install-Package dbup-consolescripts

Although dbup-consolescripts does not have a dependency on the dbup package, it is assumed you are using the following commands against a DbUp project.

Commands

• New-Migration "[Name]" - Creates a new migration .sql file in the \Scripts folder of the current project and marks it as an Embedded Resource. Uses the timestamped name format %y%m%d%H%M%S.sql (i.e. 150411194108.sql for 04/11/2015 7:41:08 PM). Optionally, specify a [Name] which will be appended to the file name.
• New-Migration-Dynamic "[Name]" - Same as above, but doesn't include the file in csproj.

Csproj needs to have a "BeforeBuild"

<Target Name="BeforeBuild">  
    <ItemGroup>
        <EmbeddedResource Include="Scripts\*.sql"/>
    </ItemGroup>
</Target>

• Start-Migrations - Runs any pending migrations by building and running the current project.

When this package is installed, the above commands can be run from the Package Manager Console. Note: make sure the "Default project" selected in the Package Manager Console is your DbUp project before running these commands.

Development

Release Process

1. Install the latest version of Mono.
2. Ensure Ruby and RubyGems is installed
3. Ensure NUGET_API_KEY environment variable is set
4. From root project folder, run:

• bundle install
• rake "release[1.2.0,Release notes here...]".