I need to know if it exists a Microsoft tool to model the data structures of a data warehouse. I generally use the SQL Server diagrams but I'd like to know an enhanced tool. Visio?
You could download a 60 day free trial of Visio; -
Have a look at a related link; -
Kieran Patrick Wood http://www.innovativebusinessintelligence.com http://uk.linkedin.com/in/kieranpatrickwood http://kieranwood.wordpress.com/
Sometimes I use DBSchema.
the good thing about DBSchema is that you can use it for synchronizing different environments. you can build your model from scratch, and then this will generate the database tables for you.
SQL Server MVP
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
Would you like to participate?