The ability to create database unit tests within Visual Studio is one of the exciting features of VSTE for DB Professionals. I work in Test on this product. But in previous jobs when I have had to maintain databases and database applications, how I could have used this product. The number of times I might find that someone had changed the stored procedure and broken the application, or renamed a field and broken the stored procedure. If I could just have run unit tests on my stored procedures on a nightly basis and made sure that all was still running correctly, that would have been great. Or if it wasn't I would have known right away. Now you can!!
Another benefit of the database unit testing feature is that it integrates into the Team Test structure if you already have Team Test or Team Suite with Visual Studio. So you can run your unit tests for your code and your database unit tests over night to check that your whole application has not regressed. Just add database unit tests to an existing or new test project. The database unit tests can be run from the test view or from Test Manager just like any existing unit tests. So now you can have a list that combines both and run that overnight from the command line using mstest. This is neat.
Or if you just have Visual Studio Pro and want database unit tests you can do that too. Just create your database unit tests and run them from the test view or the command line using mstest.
