A Little help...Testing Database SP's.
-
Hi folks, I'm currently working on some new functionality using Agile, and Test Driven Development where we can. I'd like to extend our foray into Test Driven to our database stored procedures so we can black box test them from .Net, and also automate the testing if possible (which looks like it might be no mean feat!) Add to that, we have Oracle and SQL-Server databases which have identical logic, and would like to ensure that:
- The testing can be performed on both database types (or any for that matter), which ensures versions of the stored procedures for different SQL languages are working as expected.
- It can be used with our existing projects, without causing any detrimental effect.
- If possible, it can be used fairly quickly, for obvious time constraint reasons
We currently us NUnit for testing business logic, so anything that can integrate into this framework easily would help. also we use Cruise Control, for continous integration So if anyone knows a good book, advice, experience or highly recommended online resource would help on the subject of database logic testing. Anything that would give me a starting point would be ideal, as I've got a little bit of information overload! If this isn't the place to post this please let me know. I'll repost in the right place. Any help is really appreciated. Cheers,
Billy. MCPD Windows Developer "Duct tape is like the force, it has a light side, a dark side and it holds the universe together!" - Anonymous "Experience is that marvelous thing that enables you to recognize a mistake when you make it again." - Franklin P. Jones my holding page..more coming soon!
-
Hi folks, I'm currently working on some new functionality using Agile, and Test Driven Development where we can. I'd like to extend our foray into Test Driven to our database stored procedures so we can black box test them from .Net, and also automate the testing if possible (which looks like it might be no mean feat!) Add to that, we have Oracle and SQL-Server databases which have identical logic, and would like to ensure that:
- The testing can be performed on both database types (or any for that matter), which ensures versions of the stored procedures for different SQL languages are working as expected.
- It can be used with our existing projects, without causing any detrimental effect.
- If possible, it can be used fairly quickly, for obvious time constraint reasons
We currently us NUnit for testing business logic, so anything that can integrate into this framework easily would help. also we use Cruise Control, for continous integration So if anyone knows a good book, advice, experience or highly recommended online resource would help on the subject of database logic testing. Anything that would give me a starting point would be ideal, as I've got a little bit of information overload! If this isn't the place to post this please let me know. I'll repost in the right place. Any help is really appreciated. Cheers,
Billy. MCPD Windows Developer "Duct tape is like the force, it has a light side, a dark side and it holds the universe together!" - Anonymous "Experience is that marvelous thing that enables you to recognize a mistake when you make it again." - Franklin P. Jones my holding page..more coming soon!
-
Have you read this MSDN Magazine Article Apply Test-Driven Development to your Database Projects[^]
Richard, Thanks for the link.. I'll take a look. It does look like its Team System specific, but could be a starting point. Cheers,
Billy. MCPD Windows Developer "Duct tape is like the force, it has a light side, a dark side and it holds the universe together!" - Anonymous my holding page..more coming soon!