Post reply

Auto populate database with random data

  • August 6, 2008 at 2:46 am

    #103553

    Hi all :),

    I'm looking for a tool to auto-populate my database with large amounts of random data, for test purposes.Can anyone help me in this regard.

    Thanks in advance,

    Kiran

    Kiran

  • August 6, 2008 at 8:51 am

    #853878

    http://www.red-gate.com/products/SQL_Data_Generator/index.htm

    You could also just loop through it and do it manually.

    MCITP, Database Administrator
    A hodgepodge of Information Technology and Life
    LinkedIn Profile
    My Twitter

  • August 7, 2008 at 4:19 am

    #854327

    Visual Studio Team System Database Edition (aka Data Dude) contains a random data generator.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • August 12, 2008 at 5:33 am

    #856585

    can u provide me with download link for Data Dude (free version)

    Kiran

  • August 12, 2008 at 10:54 am

    #856888

    kiran (8/12/2008)

    can u provide me with download link for Data Dude (free version)

    Hehe. There is no free version. Visual Studio Team Edition is the highest level edition of Visual Studio. From what I've heard, single user licences are on the order of $4000

    Redgate's SQL Data generator is far cheaper. It might be worth seeing if your company has a licence for Team Suite though.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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