Adding data generation in test step

• 
  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
  

  david connell September 05, 2017 12:54

  - 0 +
• 
  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

  Giorgi September 05, 2017 13:25

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

  david connell September 05, 2017 17:31

  - 0 +
• 
  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.

  Michelle T September 07, 2017 10:49

  - 0 +
• 
  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

  Giorgi September 07, 2017 11:49

  - 0 +

Add comment

Please sign in to leave a comment.