srinivasulub1981

 Profile Answers by srinivasulub1981 Questions by srinivasulub1981

• Nov 27th, 2009

 

HI

Our DB is also upgrated, then we have performed E2E testing on application whether the data is inserting into database and retrieving correctly, this nothing but verifying the old queries also working fine for newer version or not.


CNU

kurtz182

 Profile Answers by kurtz182 Questions by kurtz182

• Nov 29th, 2009

 

1) Test the upgrade itself.  Do problems arise?  Has anything new been introduced that needs to be accounted for?  If so, make sure it works properly.
2) Run functional tests that rely on the database to ensure they function properly.   
3) Run performance tests to ensure data is obtained within specified performance parameters. 
4) Ensure data integrity is maintained after upgrade.  Contstraints, for example, should still be handled as expected.

5) Run load and/or stress test to ensure the upgraded database still handles user load and performs well under the most business-critical resource-intensive circumstances.
6) Test the Oracle client.  Ideally, any issues will have been caught in the upgrade test, but it is a necessary step in the process.

virgosls

 Profile Answers by virgosls 

• Apr 23rd, 2010

 

1. Identify and execute the testcases which can exercise all the database operations from application.
2. Execute automation scripts
3. Execute performance tests
4. Identify and execute testcases which update the existing records to test the backward compatibilty.