Database Version Control Ideas

I work as a ERP admin/developer and I was curious what your thoughts are on Database Version Control. Our current method is about as bare minimum as you can get, we just have three different DB servers (Dev, Test, and Production). Any of the 5 or 6 developers here can make nearly any changes they like to the Dev database, and when their project is ready for user testing they manually script their changes into the test server. From there, once tested, it gets manually scripted into the production database.

Obviously this is less than idea for any number of reasons. I've done quite a bit of surfing to see what other people are doing and the solutions run the full spectrum. Any thoughts?