What is good way of doing Database Unit testing.

Question

We are using Power Designer for Database Modelling and whenever something is changed in model (column name, datatypes etc) have go back and test all depended stored procedures and fix them accordingly.

What would be the best tool to do unit testing of database.

Thanks

Answer 1

If this is MS-SQL, someone just asked: what is the best tool to get all the dependencies between all the objects?.

Answer 2

You might want to take a look at DBUnit - it's definitely worth giving a try.

Answer 3

I've used DBFit (open source) for unit testing stored procs.

To approach the problem from a different angle, if you're using SQL Server, you might find the newly-released (free) SQL Search a useful tool for tracking down dependencies.