Test Database Upgrade

Suppose a DB has just been upgraded from Oracle 10g to 11. What testing factors will you look at?

Questions by ankit63

Editorial / Best Answer

kurtz182  

  • Member Since Nov-2009 | 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.

Showing Answers 1 - 0 of 0 Answers

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

  • 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.

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions