azure - Add Fluent Migrator Migrate step after Team Foundation Service build has finished -


i have asp.net mvc4 app , i'm using hosted team foundation service automate builds , deploy azure website.

this works great except deploying database changes.

i'm using fluent migrator specify changes database , have custom implementation of idatabaseinitializer when entity framework context spins up, migrations necessary. leaves database migration until 'first run' of application rather build , deploy.

what i'd able build attempt migration before deploys azure (and therefore fail build if there's problem migration).

is possible hosted build service? can add post-build steps can self hosted inhouse tfs?

add following .csproj file:

  <usingtask taskname="fluentmigrator.msbuild.migrate" assemblyfile="$(msbuildprojectdirectory)\fluentmigrator.msbuild.dll" />   <target name="migrate">     <message text="migrating database" />     <migrate database="sqlserver" connection="your connection string" target="$(intermediateoutputpath)your dll name.dll">     </migrate>   </target>

also make sure target added after build target so:

<project toolsversion="4.0" defaulttargets="build;migrate;test" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">

you may have noticed load msbuild task project directory. copied fluentmigrator.msbuild.dll , fluentmigrator.runner.dll assemblies project folder. when tried load assemblies packages folder got error saying assemblies not in correct format...


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more