Say, the MS SQL database is updated daily and new patches are coming out on a regular bases. Sometimes it is a new trigger implemented, or a new table, or a small change in the algorithms. And it would not be so painfull but for the number of databases - when you have to check 5-10 changes every day you start thinking about some kind of an automation...
Please could you check this and it can help: WWW.dmdirect.com and look for the article wrote by Cody Bateman at october 4, 2002. The title is: Where are the articles on DW Testing and Validation Strategy? Cody is suggeting to test a database on four level: - Integration testing
- System testing
- data Validation
and - Acceptance testing
If you have any question, fill free to email me at email@example.com
Thanks for your email and here's a short explaination about the four level:
- Integration testing is the first level of testing and validation begins with the formal acceptance of the logical data model. All further testing and validation must be based on the understanding of each of the data elements in the model and how they will
meet specfic business objectives.
The second phase of the integration testing is comprised of the verification of the physical model.
- System testing takes the final phase of integration to the next level by requiring that the testing team push the limits on the volume to be loaded into the test environment.
- Data Validation: Reviewing the mapping utilized by the ETL tool is the primary task during data validation.
- Acceptance testing begins with the final review of the data model. A listing of potential new reports must be created and data requirements to complete these reports must be identified in a process document.
Please the best is to read the article by Cody Bateman. firstname.lastname@example.org
<BLOCKQUOTE><font size="1" face="Verdana, Arial, Helvetica">quote:</font><HR>Originally posted by b72learn: Could someone point out any techniques for testing databases? Any ideas, any links would be of a great help.
Thanks in advance.
Uh...well, the first thing you're going to have to learn (if you don't already know) is what a database is and how it works. Then, learn SQL.