Is there such a software out there? It doesn't matter if the data itself make sense. I am just worried about the fields to get populated. Basically, it will read the table definitions and generate some data accordingly. It would also be great if it asks for how many rows to insert per table, whether the default values will be left blank or get populated, how to treat the varchars(to the full extent or up to a given,specified number of characters). Ideally free :) but commercial product suggestions are also highly welcome. Thank you all.
4条答案
按热度按时间eivnm1vs1#
I see there is still no answer that has been chosen as the best. Besides the solutions already mentioned in this thread, I can suggest using ApexSQL Generate – a SQL data generator tool , which has the ability to quickly generate millions of rows, using various data sources, with a variety of data generators.
It features a fully functional free trial, so you can download it and test to see if it will get your job done.
ktecyv1j2#
For mysql databases you can use
filldb.info
.It automatically generate data and fill your database tables with this dummy data
y53ybaqx3#
In case someone is looking for a simple way to do this without extra software.
We just need a function that returns a random number:
And then you can run a query like this:
Result:
Adjust the query accordingly to match your table/column names.
lzfw57am4#
the very simple SQL I use generally :