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
Jambu Krishnamurthy
Jambu Krishnamurthy
SSC-Enthusiastic
SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)

Group: General Forum Members
Points: 198 Visits: 98
Comments posted here are about the content posted at temp
Pascal Miserez
Pascal Miserez
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 1

Hi Jambu,

I have been a long time user of ERwin since 1995. All version after 3.5.2 have been very disappointing in relation with SQL Server. We have a schema with 1000 tables and it has become virtually impossible to use ERwin, even with the latest R7 of the product. When I froward engineer a database from our scema (or from a simple 4 table sample schema) and immediately after that do a complete compare, ERwin finds lots of inconsitent differences between the schema and the database where it should not find any at all!

What is your experience ?

Pascal


Noel Kennedy
Noel Kennedy
SSC-Enthusiastic
SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)SSC-Enthusiastic (118 reputation)

Group: General Forum Members
Points: 118 Visits: 57
I find the complete compare totally unusable. The Erwin data modelling tool has very little in the way of intuitive version control functions. It also has poor 'macro' functionality. Try using it to name a PK attribute and then use it as a FK and you will see what I mean.
Peter Barnum
Peter Barnum
Forum Newbie
Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)Forum Newbie (4 reputation)

Group: General Forum Members
Points: 4 Visits: 17
I have been using ERWIN extensively as well and I have found it being used by many large companies so it is a good tool to learn. It is much simpler to use ERWIN to make multi table changes than to use Enterprise Manager and of course modelling before creating reduces costs due to fewer problems down the road. While ERWIN works fairly well for design and generation of the entire schema I would agree that for the price the ability to generate correct change scripts is poor. To the point where I have generated the model to a blank database then used a SQL compare tool like Red-Gate's SQL Compare to generate the change scripts.
Jambu Krishnamurthy
Jambu Krishnamurthy
SSC-Enthusiastic
SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)

Group: General Forum Members
Points: 198 Visits: 98

I fully agree that ERWIN is not an all in all tool.
Also this is not a product review.

I am just showing how to build a Data Model, specifically
focussing on 'Forward Engineering'

I do build and maintain schemas upside of 200 tables. I use
a feature called 'Subject Areas' to handle such large models.

I should admit that I have never worked with a model comprising
1000 tables

In my opinion no tool can help us in 'Reverse Engineering' the way
the human mind wants it to be. (atleast as of where the technologies
stand today.) Here again I could wrong like ever.

I have used ER Studio and ERWIN, and neither of these tools help me
in reverse engineering a database. I first reverse engineer, and manually spend
hours, organizing the diagram, before I can start working on it.

The other two CASE tools I am aware of are Rational Rose and Oracle Case.
They may be a bit better, but I am sure there is no way they can draw the
diagram the way I wish it to be, when I reverse engineer a database.

In my opinion ERWIN as a Data Modeling tool definitely helps for Forward Engineering
a reasonably sized database.

Complete Compare as well as Macros are not so good in my opinion too.

For Comaring Database Schemas I liked Embarcadero better than any other tool,
but to compare a DB Model with a Schema, I am yet to find one.

If I am commenting something wrong, please correct me.
I know there are Gurus around.

jambu


Carlos Urbina
Carlos Urbina
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 1

Jambu,

Thank you for taking time to share your knowledge with us. We have a copy of Erwin, but have not started using it because we lacked a nice tutorial like you provided. Thanks again.


Pascal Miserez
Pascal Miserez
Forum Newbie
Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)Forum Newbie (2 reputation)

Group: General Forum Members
Points: 2 Visits: 1

Jambu,

I am not at all saying that using a tool like ERwin is a nonesense. On the contrary, I do not see how I could go along with my ERP database with the 1000 tables and hundreds of installations that need to be updated n times a year. I have also been a very satisfied user of ERwin in the past.
Reverse enginnering also was not the subject.
The worst loss of fonctionality is in the compare option. This option has also become useless when trying to shift from trigger based RI to DRI or the other way around. ERwin mixes everything up and you end up with a mess !
Formerly, the trigger based RI was a great time saver as it produced tens of thousands of lines of code automatically.

I am just very disappointed by the new versions of ERwin which work far less better than the "old" ones. I have sent e-mails with long explanations and examples to CA without ever receiving good answers.

My remarks into this forum are just there to express my surprise that you took ERwin as an example.
In my quest of a new tool, I came across Xcase http://www.xcase.com/ which seems to be working quite well so far. I have no idea what the company behind it looks like...

Pascal


Jambu Krishnamurthy
Jambu Krishnamurthy
SSC-Enthusiastic
SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)SSC-Enthusiastic (198 reputation)

Group: General Forum Members
Points: 198 Visits: 98

Thankz Pascal,

I agree with you. I should not have used
any tool and made the write up on explaining Data Modeling.
I just thought I can be of some help to
new people who aspire to become Data Modelers.
But it does not seem to have served that purpose.

I will try xCASE and see, for my own use.

Again, I fully agree that these tools help us only
to that extent. Beyond a point we Data Architects have
to slog it out , no other way.

thankz again
jambu


chung-327878
chung-327878
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 116
We stop upgrading after version 3.5 (too expensive for our small company). I did my last database design with over 200 tables directly in Sqlserver 2000 with no problems. Sure, life would be easier if we can afford a data modeling too. It would be nice if someone writes an article to compare different data modeling tools on the market.
colin.Leversuch-Roberts
colin.Leversuch-Roberts
SSCrazy
SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)SSCrazy (2.7K reputation)

Group: General Forum Members
Points: 2725 Visits: 715

I was never impressed with Erwin, I did use Popkin system architect for many years, but these tools are far too expensive for most companies. I have Visio included with Technet/msdn subscription and I probably will buy at some time dezign http://www.datanamic.com/dezign/index.html

I used the demos and was impressed - much cheaper too!



The GrumpyOldDBA
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/
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