Generate Random SQL... 
Author Message
 Generate Random SQL...
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



Sun, 31 Jul 2005 19:04:16 GMT
 Generate Random SQL...

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.


Quote:
> 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



Sun, 31 Jul 2005 20:33:24 GMT
 Generate Random SQL...
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

Quote:
> 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



Sun, 31 Jul 2005 23:13:56 GMT
 Generate Random SQL...
Paul:

SQL Server 2000 Resource Kit ISBN 0-7356-1266-8 comes with such a tool
and many others. It is a small vb program that includes the source
code.

Hope that helps.

BZ

Quote:

> 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



Mon, 01 Aug 2005 02:54:50 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Generate Random SQL...

2. EASY: SQL to generate a simple random number?

3. Generating Random Numbers in SQL Server 6.5 Stored Procedure

4. PL/SQL Generating a random number

5. SQL to Generate Random Numbers?

6. SQL 7.0 Random function, does not work like SQL 6.5 Random function

7. How to Generate True Random IDs?

8. generating a random number

9. How to generate random numbers!

10. Generating random string in a table

11. HOWTO: Generate Random Column ID as the Default

12. Generate random password as default value


 
Powered by phpBB® Forum Software