smcculloch posted on August 27, 2005 18:54
I received this question today:-
I was wondering what tools, if any, you use for tracking changes you make to
your database and returns the needed SQL.. Of course this can be done manually,
and VS.Net will track changes. Just wondering if you used something different.
Thanks
Yes, I do use something different, a similar technique that I have
used over the past few years in not just dotnetnuke system. The
technique is to write the SQL out by hand (or generator) and always use
the sql script to make changes rather then the GUI (such as enterprise
manager).
I find this is way requires more up front effort but is far less prone to error.
How do you manage your database changes?