Solved

sql automatic query builder

Posted on 2014-10-22
9
201 Views
Last Modified: 2014-10-23
hello
I am searching for [a free] tool that generates sql queries [with random data] for testing purposes.

Any suggestions?

thank you
0
Comment
Question by:pulke13
9 Comments
 
LVL 25

Expert Comment

by:Lee Savidge
Comment Utility
Do you mean this sort of thing?

https://launchpad.net/randgen
0
 

Author Comment

by:pulke13
Comment Utility
this looks like something that I need.

I need it for Microsoft sql server and I need the tool to run on windows.

Thank you
0
 

Author Comment

by:pulke13
Comment Utility
Do you have some other tool for windows??
0
 
LVL 69

Assisted Solution

by:Éric Moreau
Éric Moreau earned 250 total points
Comment Utility
this one is not free but if you can't find anything else, it does a great job: http://www.red-gate.com/products/sql-development/sql-data-generator/
0
Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 65

Accepted Solution

by:
Jim Horn earned 250 total points
Comment Utility
> [with random data] for testing purposes.
I have an article out there called SQL Server:  T-SQL recipe to create a million sample people that has downloadable T-SQL to let you create sample people and addresses.  Similar to the RedGate tool.  Feel free to use it all you want.

>I am searching for [a free] tool that generates sql queries
SQL Server Developer Edition, all versions, runs around $50 on Amazon.com.  Beyond that no idea.
0
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Thanks for the split.  Good luck with your project.  -Jim
0
 

Author Comment

by:pulke13
Comment Utility
Thanks.
To be honest , I got fired today [for some unrelated reason].
.....

But maybe I can use the info in the future :)
0
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Sorry to hear that.  Good luck with the next gig, and keep the faith.

While you're looking, we have lots of articles for you to dig into, or maybe you can write a couple of your own to show off at integers.  Or, you can go out on your own like us high-powered consultant types.

Btw did you rob a bank?
0
 

Author Comment

by:pulke13
Comment Utility
thanks, about the consulting- I don't think I have enough knowledge to be one. but who knows.

about the bank:)-  not exactly. I brought cannabis cookies that a friend gave me from his visit abroad , to the office as a joke [because I just came back from amsterdam].
The cookies did not contain any active drug compound so I though it was all perfectly legal and just a joke.
http://www.absinth.cz/product/cannabis-foods/cannabis-cookies
The guys at the office took it lightly , they know me as a joker etc.
until the vprnd saw it and immediately summoned me to a hearing [without talking to me at all], a day later I was fired.
All because of a harmless joke.
That's the story..
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Determine next b-weekly date 12 52
SQL Backup skipping a few tables 7 25
MSSQL 2014 Query Synthax 8 36
Copy Database Wizard Error 3 19
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now