|
Kobojunkie
|
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
|
|
|
|
|
|
|
|
Kobojunkie
|
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)
|
dont know if i can send you a microsoft sql sample data, but does your system run an XML platform? let me know
|
|
|
|
|
|
Kobojunkie
|
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
|
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
|
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
|
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
|
^ If you don't need millions of rows, will Adventureworks or Northwind help?
|
|
|
|
|
|
Kobojunkie
|
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.
|
|
|
|
|
|
|
|