Data Migration Subject
I have always wondered how much knowledge a tester should amass in database to be successful in his career. Albeit Database is an integral part of testing, is a tester is expected to know the granular level to high level details of a database also? I am under the impression, that the tester should be aware of the database structures, simple queries, joins, and operational level knowledge of procedures and sequences as most of the times the database developers write the latter ones.
Also, would be nice if someone could throw up more light on database migration project.
Re: Data Migration Subject
In my own experiences, which may vary from others, having basic knowledge of the database suffices for most testers. The ability to complete the functions that you talked about is just about what I would expect for most people.
That said, it sort of depends on what you're testing for. Some folks won't ever get beyond knowing what sort of database is being used in the application, but if they're doing manual testing through the GUI front end, they might not have to know much more than that. If the tester is responsible for writing automated harnesses or executing unit and integration level testing, though, they might have to know a lot more.
In most data migration projects I've been involved in, the main goal of testing is to determine that all of the data that existed in Database A still exists in Database B, and can be accessed properly, and represents the same things it used to represent. Some of this can be accomplished through comparison testing on the databases themselves, and in some cases testing through the application is also necessary to ensure that any prepared statements or other queries from the application can still be properly completed and returned.
I'm not sure what kind of light you need, but that's some basic information based on my own thoughts [img]/images/graemlins/smile.gif[/img] If you have questions and asked them more pointedly, others might be able to provide more insight as well.