Invoking the data generator from the command line

Do we have the ability to invoke the data generator from the command line or as a part of the deployment of the database (i.e. using theDeploy Selectioncommand)?

This would be useful in automated build setups where we need to perform some sort of intermediate check after a successful creation of the database on the server but before actually loading some (test) data in it.

-Tanveer Rashid

[560 byte] By [TanveerRashid] at [2008-2-14]
# 1
I am pretty sure I heard them say that you will be able to use the data generator from the command line, but I am not sure if it is in the current CTP or not.
MickeyG at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 2

In CTP3, we do not provide a tool/executable to invoke a data generation plan from the command line. However, we do provide a public API for invoking a .dgen so you can write a simple executable yourself. The call you need to make is:

DBTest.GenerateData(
string dataGeneratorFilePath
,
string connectionString);

The DBTest class is located in namespace Microsoft.VisualStudio.TeamSystem.Data.UnitTesting.

Thanks!

JonLiperi at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...
# 3

DataGenerator is also exposed as a MSBuild task. This makes it very easy to incorporate DataGeneration into any build process. A simple project file using the MSBuild task is:

<Project DefaultTargets="DataGen" xmlns="http://schemas.microsoft.com/developer/msbuild/2003">
<!--Import the settings-->
<Import Project="$(MSBuildBinPath)\Microsoft.VisualStudio.TeamSystem.Data.targets" />

<Target Name="DataGen">
<DataGeneratorTask
ConnectionString="$(ConnectionString)"
SourceFile="$(SourceFile)"
PurgeTablesBeforePopulate="$(PurgeTablesBeforePopulate)"
/>
</Target>
</Project>

There are other options on the build task and I would expect this to be flushed out more in future releases.

J.D.Laflen at 2007-9-10 > top of Msdn Tech,Visual Studio Team System,Visual Studio Team System - Database Professionals...

Visual Studio Team System

Site Classified