Search code examples
sqlunit-testingdatabase-testing

What is good way of doing Database Unit testing

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

Solution

  • 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.