SQL Server Performance Forum – Threads Archive
Data for Database Testing
Hello; Might be an odd or obvious question, but.. I was wondering what everyone was using to generate test data for database testing? ie lists of first names, last names, addresses, countries, states for countries, cities, etc.? I have found a couple of *.XLS files for first and last names on the net. But haven’t found anything useful for addresses, etc. I am using Excel to generate some of the other data I need but thought I would ask in case there is a resource readily available that I am unaware of. Sorry if this is a tpic already covered, the search function on the forum keeps timing out on me. TIAWelcome to the forum!
Get such free tool to generate test data fromhttp://search400.techtarget.com/tip/0,289483,sid3_gci1165699,00.html fyi. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
Hi Satya, thanks for the response. Does SQuirreL contain files with lists of names? Or does it generate random data? I have Toad for SQL and EMS DataGenerator for setting up and injecting the data – but I am looking for some, somewhat real data to inject. I want to inject 1,000 – 10,0000 records in various tables and do some performance/stress testing in new database I am working on. I have some formatted applicaton data from the client I can randomize for some columns, other columns I can just generate random data for, but some data like street addresses I would like to inject data that is fairly realistic (well formatted, looks like a plausible address). I know it sounds a little anal but some of the query results will be used in a presentation for the client and I know they will squalk if the underlying data looks odd. I also am looking for some kind of list that breaks countries, states in each country, and cities in states in each country – for filling out some tables. I am new to databasing and just haven’t come across any such list, but it has to be out there without me having to use an atlas.. thanks!
If you have any specific test data requirement then better to speak to that corresponding providers, if not they aregood to go and also refer tohttp://www.sql-server-performance.com/gv_stress_test_lessons_3.asp and support toolshttp://www.microsoft.com/downloads/…53-893a-4aaf-b4a6-9a8bb9669a8b&displaylang=en for such testing. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
"if not they aregood to go" So you are saying Squirrel contains the data files I am looking for? Or that it generates random data for columns? Thanks
http://www.sqlmanager.net/en/products/mssql/datagenerator
http://www.sqledit.com/dg/
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
MohammedU; Thanks for the reply. I have both those apps – but I am looking for a datafile/dataset to inject with those apps. EMS will generate random data but it is just random character strings, which are sort of a pain to use if you are looking at the results of a query. I ran across one dataset of unique street addresses at the US federal stats bureau, but they want $500 USD for the file – and I really can’t bill that into the project I am working on.. Thanks!
I have a file that I pulled of the net that has ~88,000 last names (and two others with Females firsts and Male firsts). So I just used Excel to randomize a 4 digit #, and list of street type names (Avenue, Cresent, Mews, etc.), and concatenated them all together for 65,000+ unique street addresses. I have the USA & Canada for States/Provinces so I might just go with that – or sit down and go throughhttp://dir.yahoo.com/Regional/Countries/ to pull more states/cities for other countries. I was thinking I might pull down a few free bulletion board (forum) software packages – I think they might have filled in Country/State/City tables in the MySQL db…
]]>