A public forum for discussing the design of software, from the user interface to the code architecture. Now closed.
I have a bunch of SQL server tables and want to fill them with some random data -- for e.g. book name, book publisher, publishers address etc.. lets not worry about correctness of data. Just for test purposes.
Anyone know any aut-generation utilities? or is Perl my saviour?
Thursday, March 31, 2005
Yup, I've generated random strings of data by first generating a random number for the length of the string, then generating MORE random numbers for the characters (0..256) and then throwing out the non-character data.
Are you sure you want to do that? It might be more helpful to take 100 names out of the phone book, select among those, and add numbers after them. Thus, I could be AllanL5, there could be an AllanL4 and an AllanL6.
Friday, April 01, 2005
Perl is your saviour, of course, but very often it makes more sense to google for a test data source rather than write a script to generate it. People names, book names, geographical data - it all can be found "en masse" easily.
Saturday, April 02, 2005
umm...the problem is a little more than filling 1 table. What if I had 10 tables? each with different columns..
this begs for a utility, which I think I'll write and maybe it'll help others too..
Monday, April 04, 2005
This topic is archived. No further replies will be accepted.Other recent topics
Powered by FogBugz