Just not there yet, IMO

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Just not there yet, IMO

Postby Peeks » Tue Nov 09, 2010 5:52 am

Hi RG team.

finally had a chance to play with this product, v 1.2.0.286

It's good for really really simplistic data schema's. We've got schema's that are a fraction more complex (to pretty complex) and it's really hard getting usable data in.

Here's some scenario's which we want to do.

1. Abstract Parent Table.
2. A few children tables.

eg.

Parent -> Animal
Children -> Cat / Dog / Fish (and each one of these has their own unique meta data).

So we would love to insert 3000 rows into the Animals table.
then the first 1-1000 into Cat. 1001->2000 into Dog and 2001->3000 into Fish.

Secondly, we would also love to have some fixed data. Eg. the first 10 rows are some specific data, with the rest being random. Would be great to use the PREVIEW window to enter this data and the rest are auto-gen'd. Of course, we can run our own update script afterwards to get this, but u get the idea...

Provide, out of the box, some huge Latin list of words which can be used to generate random Latin sentences. This could also include a min/max length per sentence.

Good initial product though ... but just not that useable just yet, for us.
Peeks
 
Posts: 3
Joined: Tue Sep 21, 2010 4:41 am

Postby CraigOttley » Fri Dec 17, 2010 12:37 pm

Have you had a look at Ben Halls post about embedding IronRuby or another language?

http://www.simple-talk.com/content/article.aspx?article=697
CraigOttley
 
Posts: 13
Joined: Thu Jul 15, 2010 11:50 am
Location: Newport Pagnell


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 1 guest