I need to build a test database with already defined table and column structures. However, I have no data in those tables and columns. I am building several queries and I am hoping to test them against some "close-to-real" data.
So, I am looking for a solution that will automatically generate logical data into these tables. (like date values to dates column, strings into text column, etc) I also want this solution to be more flexible, like I would tell this solution to generate say 100 rows of data or generate the dates with an hour interval.
Obviously, such a query can be built from scratch but i do not want to rediscover America and spend much time on something that has already been done.
Please let me know if such tool exists.
Thank you in advance