Need program to generate DB Test Data

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  December 28, 2001 at 10:04 am

  #105054

  Can you recommend a program, or other means, to generate lots of DB test data (e.g. 10GB) for performance analysis?

  Optimally, it's easy to setup and use and doesn't cost $4000.

  Bill

• Steve Jones - SSC Editor

  SSC Guru

  Points: 737226

  More actions

  December 28, 2001 at 11:14 am

  #421468

  Try:http://www.quest.com/datafactory/index.asp

  Steve Jones

  steve@dkranch.net

• Henrik Staun Poulsen

  SSCertifiable

  Points: 6590

  More actions

  January 2, 2002 at 3:25 am

  #421558

  Bill,

  You could also create your own script, by using a cross join, as in

  USE pubs

  SELECT au_fname, au_lname, pub_name

  FROM authors CROSS JOIN publishers

  ORDER BY au_lname DESC

  I've done that to create a list of 100000 names.

  I created 100 first names, 10 midle initials, and 100 surnames in

  three small tables. Then I created my cross join, and got a lot of data.

  I used a random function to create data in related tables as Zip codes, marital status etc.

  Best regards

  Henrik Staun Poulsen

  Stovi Software

  Denmark

• nigelrivett

  SSCertifiable

  Points: 5472

  More actions

  January 2, 2002 at 5:42 am

  #421561

  I usually do this via a loop.

  Either calling things test0001, test0002 ...

  or by generating random values if the distribution is needed.

  It's quite quick to do.

  
  Cursors never.
  DTS - only when needed and never to control.