<p>About a year ago, I picked up Scott Ambler's <a href="https://rads.stackoverflow.com/amzn/click/com/0321293533" rel="noreferrer" rel="nofollow noreferrer">Refactoring Databases: Evolutionary Database Design</a>. I was won over to the idea that just as you can develop your code with TDD, you probably should be covering your databases with unit tests (at least) or even writing database tests before you make a change to the schema so you do database work in a TDD style as well.</p>

<p>I really like the idea, and I have been doing this (OK, sometimes I do it) by hand for a while now, just writing regular unit tests that happen to connect to the database and check its structure against a given schema file. But I haven't found any good database change management tool-kits that might help automate this process. Does anyone know any?</p>

I only know of two unit testing frameworks:
DBUnit
TSQLUnit
As for change management, these are some recommended tools:
Redgate SQL Compare
ApexSQL
Toad
Although I am not sure if this is really what you're looking for.