Our client is one of the biggest broadband providers in the country – with high-speed Internet at speeds up to 1 Gig, TV and voice – they bring a personalized, community-oriented approach to all markets.
The client wanted to perform Quality Testing of the stored procedures that are developed in Postgres which were part of the large SQL Server to Postgres migration project. These Stored procedures were having critical functionality which had to work with zero bugs and issues.
The challenge was to quality test the Stored Procedure in Postgres for Functionality, Data Transformation, Integration, Regression, Performance and Integrity, So that the database migration was seamless to the downstream applications. The Additional Challenge was that there were no requirements documents of the stored procedures and the QA team would have to look at the SQL Server code to perform QA.
AAITCS Pvt Ltd, worked with the Client to Quality Test the Stored procedures that were developed in Postgres. After reviewing the requirements, we used the following Tools and Techniques:
- Microsoft SQL Server Management Studio for SQL Server procedures.
- SQL workbench for Postgres procedures.
- Postman to test the procedures through API.
Testing Strategy To QA the Stored procedures, we took all logic from the existing SQL Server Stored procedures that were used as a baseline for developing new PG SPs and created test cases based on the code.This activity was done as there were no requirements documents for the SPs. Test Scripts were created depending on that logic, created multiple SQL’s to test the code that are developed in Postgres.
Test Execution was done based on the test cases using the test scripts, If the expected result and actual result is matched, then we passed that test case for each Stored procedure.
Additional testing was done for Web API using Postman that called the related Stored procedure, for this we have used POST method and passed parameters to the function then will get related results on console.
- Total Number of Stored procedures tested – 30
- Total Number of Test Case Document Created – 30
- Total Number of Test Cases Created – 345
- Schedule Frequency – Daily
- Total tables – 20
- Power Users – 2
AAITCS Pvt Ltd has done the end-to-end testing for the stored procedures, through this we have achieved error free Stored procedures in PG.
While testing we have identified 57+ medium and high priority bugs. Those bugs needed to be fixed by the developers and retested along with regression testing.
We have used google sheets for management of these bugs. We used a standard template that had the bug details like summary, bug reporter, stored procedure owner, environment, priority, bug severity, status, identified and completed dates.
Benefits of testing the SPs were that the end user and applications got error free stored procedures at the end of the project. Also we were able to identify critical bugs at the early states before UAT and Production implementation. We got client appreciation for helping them to find out more bugs in the Stored Procedures and it helped to prevent escalations.
Once testing has been done we send a Sign Off email of all Stored Procedures tested and client approved. This project was completed in 3.5 months. AAITCS Pvt. Ltd delivered the project on schedule within budget as we had excellent Quality Assurance experts.
AAITCS Private Limited is an innovative information technology services firm offering world class software solutions. We are client-centric and relationship-based company with a focus to provide cost-effective software development and support solutions. We focus on quality and delivering business value.
Incorporated in the year 2018, AAITCS Pvt Ltd, has been actively helping global cooperation to innovate and transform their businesses utilizing IT. Our global delivery and engagement models help us to office affordable long-term software solutions that meet our clients IT challenges and add business value. We combine our capabilities to invent, develop, and deliver innovations for clients to transform legacy models to take their business to the next level and create the future.
AAITCS has a team of expert Data architects and engineers to help you build a robust, secure and scalable architecture for your data warehouse. We are highly experienced in constructing unique architecture and conceptual data models for a variety of domains and segments. We work with cutting edge technology into Data Warehouse Migration, Data Modernization and Data Analytics also application development and empower businesses through automation to help clients attain excellence.