automated database testing with testingwhiz - step up your data potential
TRANSCRIPT
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Automated
Database Testing Step up your data potential
- Nirav Sanghavi
4th Feb 2015
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
About TestingWhiz
Easy and Intuitive Test Automation Solution
Web Cloud Mobile
Increasing productivity with smart test automation
More than 15500 downloads
Featured in:
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
1. Importance of an Automation Strategy for Database Testing
2. Common Challenges
3. What can be automated with TestingWhiz?
– Database Automation Testing
– Data Comparison Testing
– Data Validation Testing
– Database Health Check
4. Demo
Agenda
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Executing tests partially or repeating tests unnecessarily can cost you huge. A separate test plan is recommended.
Its vital to identify regular database tests to cover data validation, schema verification and security checks.
All critical modules of the application should be bound with RBT for database scripts to balance time, cost and quality aspects.
Importance of an Automation Strategy for Database Testing
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Automation Strategy for Database Testing
Identify Scope Test script
PreparationData Certification
Test Script Execution
Drilled down Reporting
Post Execution Monitoring
Integration with Scheduled Jobs
Cross Check with UI Testing Report
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Going Agile - Frequent application releases
Checks for best practices and standards enforcement
Frequent changes in database schema
Data integrity tests are always tricky
Repetitive database testing cycles
Issues are not producible on staging or QA environment but appears on production.
Common Challenges
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
What could be automated?
Data integrity Checks
Performance Checks
Database schema Checks
Database security Checks
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
What could be automated?
Periodic reporting to Managers
Admin module is yet to be built but daily reporting
is needed
Perform cleanup action
on regular basis
Insert test data to dev or QA database
when required
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Database testing with TestingWhizCode less approach to do database Testing - Less time required for back end verification
Supports multiple databases
SQL queries can be included as part of the Test Scripts for verification purpose - Easy integration with Functional Testing
Reusable scripts can be shared across teams
Scheduled jobs can be triggered for regression aspects - Reduced complexity and maintenance
In case bugs found, can be reported to Jira/Mantis/Fogbugz
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Live Demo
– Data Comparison Checks
– Data Validation Checks
– Database Schema Checks
– Database intrusion Checks
© TestingWhiz Email: [email protected] | Twitter: @itestingwhiz
Questions?
Free Trial: www.testing-whiz.com/download
Toll Free: 1-855-699-6600
Email: [email protected]
Thank You