Somehow Microsoft decided not to include this feature in 2010 version of Visio.
Visio Forward Engineer Addin for Visio 2010, adds the ability to generate the database scripts directly from the database model defined in Visio 2010. It is developed in C#.