Paragrah/sentence generation

The simplest way to populate your database with test data.

Moderators: David Atkinson, Anu Deshpande, Lionel

Paragrah/sentence generation

Postby whenriksen » Thu Jul 15, 2010 5:33 pm

I'd like to see text columns filled with a somewhat realistic word/sentence structure. I don't really care if it the text doesn't make sense. Currently it appears the only option is a regexp which just fills in with letters and numbers.

Would it be possible to create a Lorem Ipsum generator (or an english equivalent) for text fields? I'd also like to see the string length variance be a configurable option.

This:

Proin magna leo, bibendum vitae fringilla vel, sagittis nec mi. Suspendisse potenti. Cras eu dolor a elit ultrices tempor sed sed dolor.
Etiam eu tortor porta magna condimentum hendrerit. Sed ut quam consequat dui sodales rutrum sit amet quis dui posuere.


can make a big difference over this:

VX1XY7FLX1C61HJIZZO8X62N433FEJO0MQ83ZRUGBOPKTTQTDIPS0RDNUIEARPTMDTPUCLL34U0TE312YRKTWB6C7FNNJUV1S9NMYE0RHQE2PD19XKNOPXMB8JER34QUTN3AVCR8UBLAM77DPS63LTWWQLDX49QYA5OKB902JNWZUKC7TG3CLUR0YZ47LI7EL5AWL7B4R0X9UIEFIAMZI2GSUB3BYL8JOY73BDCNYRXEWUGV56Z5C4VS4IIRBHJ

when working with screen flow and page layout issues.
whenriksen
 
Posts: 16
Joined: Thu Feb 18, 2010 5:07 pm

Postby Anu Deshpande » Mon Jul 19, 2010 1:47 pm

Many thanks for your post.

Have you tried Generator option 'Description ' from shopping section? I hope that is much closer to what you are looking for.

Which will generate data:

Code: Select all
Id eudis quo linguens imaginator pars fecit.  Et quad estis vobis homo, si quad fecit, non apparens vantis. Sed quad ut novum vobis regit, et nomen novum eggredior.  Longam, e gravis et pladior venit.  Tam quo, et bono quorum glavans e funem.  Quad rarendum habitatio quoque plorum fecundio, et quis gravis delerium.  Versus esset in dolorum cognitio, travissimantor quantare sed quartu manifestum egreddior estum.  Multum gravum et plurissimum parte brevens, non quo plorum in volcans essit.  Pro linguens non trepicandor si nomen transit.


Kindly let me know if this is not what you are looking for.[/img]
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge

Postby whenriksen » Mon Jul 19, 2010 3:35 pm

Perfect.

Thanks.
whenriksen
 
Posts: 16
Joined: Thu Feb 18, 2010 5:07 pm

Postby Anu Deshpande » Thu Jul 22, 2010 1:50 pm

Thanks for your confirmation we are pleased your issue is resolved!
Anuradha Deshpande
Product Support
Redgate Software Ltd.
E-mail: support@red-gate.com
Anu Deshpande
 
Posts: 692
Joined: Mon Apr 20, 2009 3:53 pm
Location: Cambridge


Return to SQL Data Generator 1

Who is online

Users browsing this forum: No registered users and 0 guests