Can anyone recommend a reliable data modeling and schema generation tool.

I used to quite happily use Erwin 3.5 until Computer Associates took over development at which time the application became unstable and extremely buggy.