Post reply

Get Testdata

  • July 3, 2012 at 1:45 am

    #260788

    where I can i get real testdata (PK, LastName, Firstaname) -only 3 columns-

    I think of about 1 million data - 500T.

    regards

    Nicole;-)

  • July 3, 2012 at 7:02 am

    #1508216

    Hi Nicole,

    Some of the experts here likely have homegrown scripts that they can share.

    However, I found Redgate's SQL Data Generator to be a very good tool and it's inexpensive.

    Steve

  • July 3, 2012 at 7:08 am

    #1508219

    here's a link to the US Census data that has a list of the miost frequently occuring male firstnames, female first names, and lastnames.

    a cross join of all that data will give you a whooping large example of fake data:

    http://www.census.gov/genealogy/www/data/1990surnames/names_files.html

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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