Post reply

Need program to generate DB Test Data

  • 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

  • December 28, 2001 at 11:14 am

    #421468

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

    Steve Jones

    steve@dkranch.net

  • 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

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

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply