We have released a toolkit for automating the generation of tables and collapsing views. The toolkit contains an XML Schema specification for anchor models, together with an XML file of an example model, and an XSLT translating the XML into an SQL Server 2005 script. The script sets up all tables with indexes as well as the latest and point-in-time collapsing views. We will continue our work on this “tool” in order to simplify its use.
Please note that this toolkit has been deprecated in favor of the online modeling tool.