We need to implement change management in our shop, and I am wondering what experiences you have had with various CM products ?
What we want to do is to put version control on stored procs, user-defined functions and DTS packages; be able to recover an earlier version of any of these if we put a bad one in by mistake; sync databases; promote databases from Development to Production environments; get alerts when changes occur outside version control ... that sort of thing.
We have seen various products that offer all or some of these features (usually some). A thing called SQLDBControl looks fairly promising to us at present, but ... there's no substitute for the experience of the pros to guide the way.
What's been your experience ?
Thanks for any help !!
What we want to do is to put version control on stored procs, user-defined functions and DTS packages; be able to recover an earlier version of any of these if we put a bad one in by mistake; sync databases; promote databases from Development to Production environments; get alerts when changes occur outside version control ... that sort of thing.
We have seen various products that offer all or some of these features (usually some). A thing called SQLDBControl looks fairly promising to us at present, but ... there's no substitute for the experience of the pros to guide the way.
What's been your experience ?
Thanks for any help !!
