Re: Generate Random SQL...

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.com>
Date: Wed, 12 Feb 2003 15:13:56 GMT
Message-ID: <Uwt2a.75123$2H6.1786_at_sccrnsc04>


That may not accomplish what you want. For example, if you are just running a script with these sql statements that will not be the same as a well written application. Why? For example, you won't be using bind variables and that makes a huge difference.
Jim
"Paul Wo" <pwolmering_at_yahoo.com> wrote in message news:QSp2a.83604$be.64369_at_rwcrnsc53...
> Hi,
>
> I'm in need of a program that will generate random SQL statements
> (Select/Insert/Update/Delete) based on bound conditions; DDL, # of joins,
 #
> of expressions, etc.
>
> Has anyone built such a beast and/or know where one might exist?
>
> Why: I need to stress an application by testing large volumes of SQL
> statements against a couple of the major databases. And it'll take me too
> long to create such a program.
>
> Thanks.
>
> Paul
>
>
>
Received on Wed Feb 12 2003 - 16:13:56 CET

Original text of this message