Post reply

Looking for a tool to randomly populate a DB

  • November 8, 2004 at 6:10 am

    #102268

    Dear all,

    I want to build up a database to perform some performance tests. I need to populate 10 tables. Some of them are linked with secondary key constraints or have unique indexes and/or primary key. Are there tools that could randomly populate those tables while enforcing the constraints ?

    Thanks

    Patrick

     

    Patrick Duflot

  • November 8, 2004 at 7:12 am

    #529263

    The resource kit for SQL2005 Beta2 contains a tool called databasepopulator. I think it will also work for SQL2K. Another option, though it's not free would be Quest Software (http://www.quest.com), which has a tool called datafactory which does what you want.

    M

    [font="Verdana"]Markus Bohse[/font]

  • November 9, 2004 at 6:55 am

    #529432

    I'll check that out

    Thank you Markus

    Patrick

    Patrick Duflot

  • November 9, 2004 at 11:38 pm

    #529554

    Database populator also works for SQL2K as well as SQL 7.0. It should work for the table dependencies that you described.

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

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