Wednesday, December 19, 2007

How do you test your database?

This is a very generic question. I will be describing my generic database testing method as well as stored procedure testing methods.

Testing Databases:
  • Table Column data type and data value validation.
  • Index implementation and performance improvement.
  • Constraints and Rules should be validated for data integrity.
  • Application field length and type should match the corresponding database field.
  • Database objects like stored procedures, triggers, functions should be tested using different kind of input values and checking the expected output variables.


Testing Stored Procedures:
  • Understand the requirements in terms of Business Logic.
  • Check that code follows all the coding standards.
  • Comparing the fields' requirements of application to the fields retrieved by a stored procedure. they should match.
  • Repeatedly run stored procedures many times with different input parameters and compare the output with expected results.
  • Pass invalid input parameters and see if a stored procedure has good error handling..


No comments: