My SQL for QA process

 

After conducting black box testing for accounting system, we have to obtain quality assurance for test the live web system. There we have to check database connections with local server to the live web server. 

Developers has used a temporary database table file in live web system because it will generate more risk for data records which are sending directly to the live web server through local web server. By allocating a separate temporary web server table, there is a chance to mitigate the risk of violating data records. 

The process of transferring data to live web server is 

1. Enter data to system
2. Transfer data from system to local web server
3. Transfer data from local web server to temporary live web server
4. Transfer data from temporary live web server to original live web server 

In this process, we have to maintain a QA process for checking the database connection to check

1. Whether all the data records are transferred to temporary web server or not
2. Whether all the data records are transferred to temporary web server without any data violating or not
3. Whether all the data records are transferred to live web server or not.
4. Whether all the data records are transferred to live web server without any data violating or not. 

For achieving this QA process task, we have to learn about my sql for checking database connections. In here we used some sql commands such as SELECT,UPDATE,LIMIT,WHERE for checking the connection.

some of those queries we wrote for that is

1.    SELECT         *         FROM         tblpersonalaccount         WHERE fld_Section='I'
2. SELECT COUNT(*)   FROM      tblpersonalaccount    WHERE fld_Section='I'
3. UPDATE tblpersonalaccount SET backup_flag=0 WHERE fld_Section=’I’ LIMIT 100; 
    
    2015.08.31