SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5
  1. #1
    Member
    Join Date
    Oct 2008
    Posts
    42
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    opensource tool for database testing

    hi
    any body please let me know
    we have lot of opensource performance tools.
    could u give me a better idea which is better opensource tool.
    for database testing which opensource performance tool is better? give the link for download?


    regards
    neeli

  2. #2
    Member
    Join Date
    Jan 2003
    Posts
    40
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: opensource tool for database testing

    You could use a combination of JUnitPerf and dbuint. or JUinitPerf and sqlunit. It would involve java coding.

  3. #3
    Moderator
    Join Date
    Aug 2001
    Location
    NC
    Posts
    6,018
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)
    Total Downloaded
    0

    Re: opensource tool for database testing

    JMETER with JDBC COnnections to the database servers.

    If you need to engage in performance testing tool then pick a tool designed from the outset for performance testing, otherwise you could work yourself into an efficiency problem with the tool akin to using the butt end of a screwdriver to drive nails. This is not to suggest that a screwdriver is not an immenently useful tool, but that its design efficiency is in an area other than that of driving nails. Same holds for performance testing tools vs unit testing tools.

    A short trek over to google should provide a link or two or three for downloading JMETER

    Now comes the big, ugly questions
    <ul type="square">[*] Does your team have the skills to use the tool effectively[*] Will the tool report in such a way to make it easy to report against your requirements[*] Will this tool work in your environment?[*] Will this tool monitor your infrastructure to allow you to identify bottlenecks effectively[/list]

    You can quite easily have a negative ROI if your tool is a poor fit for your needs and your organization's skills, independent of licensing model.
    James Pulley

    Replace ineffective offshore contracts, LoadRunnerByTheHour. Starting @ $19.95/hr USD.

    Put us to the test, skilled expertise is less expensive than you might imagine.

    Twitter: @LoadRunnerBTH @PerfBytes

  4. #4
    Advanced Member
    Join Date
    Jan 2002
    Location
    ma
    Posts
    531
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    With today's readily available stack, the ideal combination is:
    - Maven with
    - SQLPlugin to drop/create tablespace/user/schema
    - liquibase plugin to manage schema
    - DBUnit plugin to import and export data
    - TestNG
    - Functional testing with dataprovider, groups, etc using JDBC and DBunit for helper class
    - JMeter
    - Performance testing. (Will require modification for better stats, etc)

    With a competent person writing the tool, it's a very fast work. Provided I have the basic resources (Like pristine data/scripts), it typically takes me one or two 2 week sprint to whip up a simple prototype for functional testing framework. A hierarchical configuration engine that takes series of parameters and constructs test suite will take another one to two sprints. Taking those and pushing into a load tool with JMeter is another couple of sprints. The testing will depend on each case.

    For database configuration, it's not that hard. JDBC url and configuration files will drive much of what's needed. (Those can all be parameterized). if it's stateless (read-only), tests are very easy. State machines takes a bit longer as you have to deal with state changes.

    If you don't know what you are doing and without proper guidance, it will probably take you 3-4 years to figure out how to do all the components and properly integrate into CI.

    -Iggy

  5. #5
    Member
    Join Date
    Nov 2012
    Posts
    130
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0
    Hi Neeli1234

    For Database Testing - TestData Generator , Datatect tools are very useful.

    Here its Just Refer this link you will get more tools http://sqa.fyicenter.com/FAQ/Testing...ing_Tools.html

    Regards
    Muthu
    http://qtpbook.com/

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 9.38%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 04:30 AM.

Copyright BetaSoft Inc.