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.