Working On Creating A Test Database. Anyone With Sample Data For Free

Welcome. Please Login, Register, Or Activate! 
type your username and password to login
Date: November 22, 2009, 11:58 AM
430744 members and 297862 Topics
Latest Member: NeetIrrefstef
Nairaland [Nigerian Forum] Home Help Search Who is currently online? Login Register
Nairaland Forum  |  Technology  |  Programming  |  Working On Creating A Test Database. Anyone With Sample Data For Free
Pages: (1) Go Down Send this topic Notify of replies
Author Topic: Working On Creating A Test Database. Anyone With Sample Data For Free  (Read 129 views)
Kobojunkie
Working On Creating A Test Database. Anyone With Sample Data For Free
« on: November 03, 2009, 07:26 PM »

I am in need of data of all kinds, preferably formatted so I can transform and import it to my datatables. I am working to google what I can but if you already have some dummy data that you use and would like to help, can you please share? Even if it is a script, a database file, any thing useful will work
Thanks in advance
Seun (m)
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #1 on: November 03, 2009, 07:39 PM »

I can't imagine any use of test data that won't require a particular type of data, but:
  http://blog.stackoverflow.com/2009/06/stack-overflow-creative-commons-data-dump/
  http://en.wikipedia.org/wiki/Wikipedia_database
Kobojunkie
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #2 on: November 03, 2009, 07:44 PM »

Well, I sort of have this small Data Generator piece written to handle the types and constraints for now. What I want at this time is just to fill up with some dummy code. As time goes on, I hope to sort of filter each data by type and format for cleaner data.  Thanks for the links

Do you have more?

I need Addresses, schools, phone numbers, Text/paragraphs etc libraries
Tonye-t (m)
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #3 on: November 06, 2009, 11:04 AM »

dont know if i can send you a microsoft sql sample data, but does your system run an XML platform? let me know
Kobojunkie
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #4 on: November 06, 2009, 04:50 PM »

If you have a copy of SQL Management Studio 2005 or 2008 or any other database client tool out there that could, you can easily script the database or the data using SSIS . Also, I can you can make a copy of the database and send it my way.
Beaf
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #5 on: November 07, 2009, 03:02 AM »

You can get formatted, random data with very little effort.
All you have to do is generate random text and numbers for each field, to your target formats and lengths. Then you generate the sql using loops; alternatively, you could add rows to a datatable/dataset while you loop (that way, you can dump xml as well as test-run before db population).
You can be done in an hour.
Kobojunkie
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #6 on: November 07, 2009, 03:29 AM »

I am not looking for TRASH data per say. Looking for real world data that will work with already existing contraints, and formats that clients might have on their database. It is actually for a mini data generator that allows for using of already existing data to generate insert statements rather that generating JUNK texts and more. I need next to real Addresses, phone numbers, Names, words, geocode, Guids, Titles, etc
Kobojunkie
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #7 on: November 07, 2009, 03:31 AM »

I am trying to avoid generating text and the likes. I would rather use data that actually complies with contraints and more. Essentially, I need the Database dump to be packaged with the client so instead of generating "JUNK" text, use real text, real phone numbers, addresses, names, etc. Makes it easier to test, and makes the database reusable.
Beaf
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #8 on: November 07, 2009, 04:00 AM »

^
If you don't need millions of rows, will Adventureworks or Northwind help?
Kobojunkie
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #9 on: November 07, 2009, 05:21 AM »

I have been able to extract as much as possible from Adventure works and Northwind. But looking for more. I know essentially looking for data of different kind.  I am talking of data that pertains to schools and students, to real estate data, votes/polling data etc.   I started off wanting to write a sort of text generator, but I would rather have something non dev testers can use in testing their code and also allows for contraint and format checks needed in over 1000 columns in the current database. So I am building a library of sample data that can be used by the DataGen to generate sample data for the test database. So when QA testers try to do testing, they can easily work with it without just seeing JUNK all over the place they can barely make real sense of.
Beaf
Re: Working On Creating A Test Database. Anyone With Sample Data For Free
« #10 on: November 07, 2009, 07:07 AM »

Try these pages. There are a few open source (and commercial) dummy data generators listed in the discussions.

http://stackoverflow.com/questions/157600/data-generators-for-sql-server
http://stackoverflow.com/questions/16317/creating-test-data-in-a-database
 Materials On Network Cable  Java And Sql Server 2000 Doms Needed   Xss Hole Is Not A Threat To A Language Is A Threat To All, Cross Site Scripting.  Page 2
Pages: (1) Go Up Send Topic to Friend by E-mail Reply 


Sections: Autos/Cars (2) Jobs/Vacancies (2) (3) Career Talk Education General(2) Politics Romance Computers Phones Travel
Sports Fashion Health Religion Celebrities TV/Movies (2) Music/Radio (2) Books Webmasters Programming

Links: Page1 Page2 Page3 Page4 Page5 Page6 Page7 Page8 Page9 Page10

Nairaland is owned by Oluwaseun Osewa. See also: Nairalist Classified Ads
Nairaland Forum | Powered by SMF 1.0.12.
© 2001-2005, Lewis Media. All Rights Reserved.