Last Wednesday at our local TRINUG meeting, I was complaining about the fact that Visio no longer could generate the SQL to create a Database from a database diagram. Sure you can reverse engineer one. But the creation of a database from a diagram has been left out since version 2003. I mean why provide the tools to diagram a database if you can’t do anything productive with it?
Well I guess I should have looked a bit harder.
There is a project on Codeplex called forward engineer. http://forwardengineer.codeplex.com/ . It will generate the SQL to create tables and databases from your Visio Diagram.
This rocks, thanks guys !