Test-based development for SQL code

Question

Have you applied test development to purely sql scripts? if so, what was your experience. Is it worth it? What are the rewards? limitations? etc.

Answer 1

I played a little, to be honest, I would rather generate my regular DB code. I was this a while ago and thought it was interesting. http://sourceforge.net/apps/trac/tsqlunit/

Answer 2

(?) "" , . . . ( , ).

, . .

"".

Answer 3

SQL TDD-. , (++, , ), DBA, . , . , , ; script , .

TDD, as it is usually practiced, is not very suitable for SQL (or, maybe, vice versa), but in fact it is not so difficult to adapt the practice to work well with the language. One-button testing can be a little more difficult to add to the mix, but it is rarely difficult to complete a request.