Re: Generate Random SQL...
Date: Wed, 12 Feb 2003 07:33:24 -0500
Message-ID: <3e4a3f0e_3_at_news1.prserv.net>
Paul,
Microsoft SQL Server specific information:
I believe that the book "Microsoft SQL Server 2000 Resource Kit" has a stress testing tool included on the CD accompanying the book. To be honest, I've never used the tool, so I don't know its full abilities. It might well be limited to just generating SELECTs.
BP Margolin
Please reply only to the newsgroups.
When posting, inclusion of SQL (CREATE TABLE ..., INSERT ..., etc.) which can be cut and pasted into Query Analyzer is appreciated.
"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 - 13:33:24 CET