MS SQL Data Warehousing - Data Modeling

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

Data Modeling

Robert Hamilton

2005-04-01, 8:01 pm

What's the best Microsoft tool for data modeling of a data warehouse on SQL
Server 2000?

Thomas R. Hummel

2005-04-01, 8:01 pm

That's just about like asking, "What's the best car?" It depends on
what you will be doing with it. Do you need to model both the logical
and physical? Do you need it to do schema generation for you? Reverse
engineering? Does it need to link into SourceSafe?

The big three that I see used the most are ERwin, Power Designer, and
Microsoft visio w/ Enterprise Architect. I would suggest that you start
with these, check out the websites, download the free trials, and
compare their functionality and ease of use with what you need.

HTH,
-Tom.

pdxJaxon

2005-04-04, 8:01 pm

ER-Studio is also a very big player

Greg Jackson
PDX, Oregon

Sponsored Links