Adding data generation in test step

Giorgi

Hello, when creating Data Generator project we should specify target database. But how does such file work with SQL Build Tfs add-on, when I don't want to specify database name there (instructing Sql Build to create some temp db with some temp name)?

Michelle T

Hi there,

You should be able to create a SQL Data Generator project against any database which has the same structure as the database under test. Save the project and then specify it by file name in the VSTS interface.

DLMA will use the project file settings, substituting in the database name when it names the temporary database.

Giorgi

Hi Michelle,
Thank you for your response, that's clear for me now, Unfortunately I am unable to test the behavior now, because I'm experiencing some problems with Data Generation with DLM. As far as they are solved I will test the behavior

david connell

Sorry not too sure what SQL Build Tfs add-on is.
Assuming you don't change the schema or randomly create the schema
You could create a SQL Data Generator project against the schema
Store that project file somewhere.
Then after you have created the temp database
Modify the project file (it's only XML) with the temporary database name that you created and then use the command line of data generator to fill the database?

Hope that helps
David Connell

Giorgi

Hello,
Under "SQL Build Tfs add-on" I've meant DLM Automation VSTS Build and Release extensions
URL: http://www.red-gate.com/products/dlm/dlm-automation/add-ons

Thank you
Giorgi

david connell

Hi Giorgi,
arrr cool thank you for your response. I'll get back later
Thank you
David