Alberto Ferrari wrote a nice post with a workaround to generate tables in different SQL Server 2005 schemas starting from a single Visio document. The trick includes a SQL script to do the magic.

I hope that next Visio version would be able to do that in a simpler way.

Originally appeared on: http://sqlblog.com/blogs/marco_russo/archive/2006/09/06/how-to-handle-schema-in-visio-database-modeling.aspx