I'm stuck with using Powerdesigner to reverse engineer a schema. We are also stuck withusing it to 'develop' the schema. I'm not madly impressed with it as a DBA dev tool, but the developers like it and the project manager's gone with them.

What do you use or recommend? I'm looking for something that will tightly control the development of the schema and at the end produce the requisite scripts (in whatever format I like (!)) to create the schema.