SQL Clone
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
Mr or Mrs. 500
Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)

Group: General Forum Members
Points: 584 Visits: 98
Comments posted here are about the content posted at temp
Pascal Miserez
Pascal Miserez
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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 Veteran
SSC Veteran (282 reputation)SSC Veteran (282 reputation)SSC Veteran (282 reputation)SSC Veteran (282 reputation)SSC Veteran (282 reputation)SSC Veteran (282 reputation)SSC Veteran (282 reputation)SSC Veteran (282 reputation)

Group: General Forum Members
Points: 282 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
SSC Rookie
SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)SSC Rookie (42 reputation)

Group: General Forum Members
Points: 42 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
Mr or Mrs. 500
Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)

Group: General Forum Members
Points: 584 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
Old Hand
Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)Old Hand (384 reputation)

Group: General Forum Members
Points: 384 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
Grasshopper
Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)Grasshopper (24 reputation)

Group: General Forum Members
Points: 24 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
Mr or Mrs. 500
Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)Mr or Mrs. 500 (584 reputation)

Group: General Forum Members
Points: 584 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
SSC-Enthusiastic
SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)SSC-Enthusiastic (108 reputation)

Group: General Forum Members
Points: 108 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
SSChampion
SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)SSChampion (11K reputation)

Group: General Forum Members
Points: 11935 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