Sample MSBuild file for running MigratorDotNet migrations

Build_msbuild.xml

<Project DefaultTargets="All" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

    <UsingTask AssemblyFile="Lib\Migrator.MSBuild.dll" TaskName="Migrator.MSBuild.Migrate" />

    <PropertyGroup>
        <To>-1</To>
        <Env>Development</Env>
        <ConnectionString Condition="'$(Env)'=='Development'">Database=myapp_dev;Data Source=localhost;User Id=myuser;Password=abc123</ConnectionString>
        <ConnectionString Condition="'$(Env)'=='Test'">Database=myapp_test;Data Source=test_db_server;User Id=myuser;Password=abc123</ConnectionString>
        <ConnectionString Condition="'$(Env)'=='Production'">Database=myapp_prod;Data Source=prod_db_server;User Id=myuser;Password=abc123</ConnectionString>
    </PropertyGroup>

    <Target Name="Migrate" DependsOnTargets="Compile">
        <SetEnvVar Variable="MigrationConnectionString" Value="$(ConnectionString)"/>
        <Migrate Provider="SqlServer"
                 Connectionstring="$(ConnectionString)"
                 Migrations="MyApp\bin\MyApp.dll"
                 To="$(To)">

        </Migrate>
    </Target>

</Project>