The simplest way to populate your database with test data.
Moderators: David Atkinson, Anu Deshpande, Lionel
There are many times that we need to generate multiple discrete "clusters" of data within a single table, where each cluster may be defined by multiple columns having discrete combinations between them. For example, one cluster where Tablename.Status = Active and Tablename.InceptionDate is within one year of the current system date; another cluster where Tablename.Status = Invalidated and Tablename.DateOfReview is between a specified range; and third cluster where another set of conditions are met, etc.
If there was only a way to create multiple clusters like this using SQL Data Generator, and give a familiar name to each cluster, then I would be the happiest guy on the planet.
I'm serious. Take the supermodel guy who's boinking Halle Berry, add 15% more happiness, and that would be me. You could do that very thing for me -- *IF* you add this feature.
- Posts: 2
- Joined: Wed Jan 09, 2008 4:01 pm
- Location: Atlanta
I'm wondering about forcing certain columns of fields together in a Null or not situation. Examples are:
CC Info (date/num/name)
I'm trying, but the info doesn't make much sense if I have a 80% null scenario (for example), and trying to make sure that the values line up in some sort of logical sense.
- Posts: 18
- Joined: Sat Jul 22, 2006 1:19 am
Return to SQL Data Generator 1
Who is online
Users browsing this forum: No registered users and 0 guests