Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Data Modeling using ERWIN and SQL Server 2000


Data Modeling using ERWIN and SQL Server 2000

Author
Message
Feifarek
Feifarek
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 1641
I have not used ERWIN because it was out of my budget. The tool I have used for forward engineering (and a little bit of reverse engineering) is an affordable ($135 to 335 per user) alternative that I would recommend to people investigating these tools: Enterprise Architect. It is not dedicated to just database diagramming but the Professional version (which I own) does the database diagrams and SQL DDL work very well for SQL Server. More information can be found at http://www.sparxsystems.com/



dlhatheway@mmm.com
dlhatheway@mmm.com
Old Hand
Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)Old Hand (320 reputation)

Group: General Forum Members
Points: 320 Visits: 12

I've been using ERwin for perhaps 8 years, now, and it leaves a lot to be desired.  I've been using it less and less as time goes by, especially since SQL Server 2000 introduced the table design editor which works nicely.

Saving preference things (like the object filters) does not appear to work at all.  If there's a way to get default behaviors working the way I'd like every time I start up a new model, I've never found it.

The compare feature is just about useless.  It's certainly the case that you can create a model in ERwin, forward-engineer it out to your database, do a compare and find that the database and the model are "different."  Until recently, I often found it easier to script out databases to flat files and use the "windiff" text comparison utility that comes with Windows than to fiddle with ERwin to see how two databases differed.  Late this summer, I finally bought SQL Compare, which is great at database comparison (I can recommend it) but I shouldn't have had to spend the money because ERwin should have been able to do the job for me.

It doesn't seem to support trusted connections.

If you change things in the model and forward-engineer the changes into the databse, the forward-engineer task usually fails.

In spite of years of use, I've never become comfortable with the user-interface.

Its reporting capabilities are a joke.

The auto-layout feature doesn't even attempt to pack tables into a reasonable amount of screen real-estate.  Objects end up spread across a very wide model.





ricva
ricva
SSC-Enthusiastic
SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)SSC-Enthusiastic (106 reputation)

Group: General Forum Members
Points: 106 Visits: 228

Erwin (3.5) used to be one of my favorite modeling tools.  But alas, support and features tanked when CA bought the tool.  Most of the features are useless in a real development environment. 

I love having a visual diagram, and now just use Visio (Enterprise Architect).  This tool need alot of work also though!

My recommendation, sad to say, is to skip Erwin.  Use Visio and Word, and you will be just as far and at less cost.   





Amit Lohia
Amit Lohia
Say Hey Kid
Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)Say Hey Kid (706 reputation)

Group: General Forum Members
Points: 706 Visits: 174

Guys

The rating of this article is not a justification towards the Author. Rating should be based on the article and not for ERWin.

 




Kindest Regards,

Amit Lohia
JJ B
JJ B
Old Hand
Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)Old Hand (327 reputation)

Group: General Forum Members
Points: 327 Visits: 2846
The article aside, I appreciate the discussion here about various data modeling tools. I've been using ERwin for years. Like others, I have been rather unhappy with ERwin. Even so, ERwin does all the important things that I need it to do. Ultimately it saves me more time than it costs and helps me create better databases. I tried Visio a couple years ago and while it came close to doing everything I needed it to do, it did not have all the features that I used in ERwin. (I don't use database comparison features, so I'm not talking about that. I'm just talking about basic data modeling and forward engineering.)

That being said, I'm still looking for other data modeling tools that will work better than ERwin, especially ones that are cheaper than ERwin. I'm going to check out the three listed by people here. If someone else out there has an additional suggestion or more to add on the current suggestions, please post it!

While not the intention of the author, thanks for writing an article that got people to talk about something that really interests me!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search