Perform Visual Studio Data Compare automatically prior to running MSTest tests

Question

I need to perform a data compare operation to refresh a dev database froma sample data database prior to running integration tests using the VS test harness. Anyone know a way to automatically configure this?

Answer 1

You need the MSBUILD Schema and Data Compare Tasks

from here

MSBuild /t:SqlDataCompareTask 
   /p:SourceConnectionString=”ValidConnectionString1” 
   /p:SourceDatabaseName=”DatabaseName1”
   /P:TargetConnectionString=”ValidConnectionString2” 
   /p:TargetDatabaseName=”DatabaseName2”  
   /p:OutputPath=”FullPathForDataCompareReults”
   /p:OutputFilename=”FilenameForDataCompareResults”