sql 2k5 db diagram designer

While ERWin is expensive and owned by CA, it is still one of
the best tools out
there.  There is also a tool called Case Studio
(http://www
.casestudio.com/enu/default.aspx) that will do multiple
databases.
I have tested it as a low cost alternative for the SIG that
I am a leader of in
Houston.  It is actually pretty good.  Especially for the
price.  Your DB
Designer says it is designed for MySQL.  So I do not know
how useful it will be
for MS SQL databases.

The SQL Server built in diagramer is mainly good for adding
the relationships
and naming them.

Visio is a joke.

Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting Automatic digest processor <LISTSERVDISCUSS.DEVELOP.COM>:

> Date:    Tue, 16 May 2006 15:15:17 -0400
> From:    Shawn Wildermuth <swildermuth_listsADOGUY.COM>
> Subject: Re: sql 2k5 db diagram designer
>
> I played with DB Designer have you suggested it.  My
$0.02:
>
> - Crashed a lot on me.
> - Reverse engineering was helpful, but no diagram
auto-layout (drops diagram
> in seemingly random order so I have to spend a lot of
time deciphering the
> results).
> - No support for creating "Diff" SQL.  Will
synch with a database, but that
> is rarely what I'd like to do.
>
> I still like ER/Win but two things make me never
recommend it:  Huge cost
> (>4K/developer); Its owned by CA.
>
>
> :p
>
>
>
> Thanks,
>
> Shawn Wildermuth
> http://adoguy.com
> C# MVP, MCSD.NET, Author and Speaker
>
>
> -----Original Message-----
> From: Discussion of building .NET applications targeted
for the Web
> [mailtoOTNET-WE
BDISCUSS.DEVELOP.COM] On Behalf Of Kunle Odutola
> Sent: Sunday, May 14, 2006 4:39 PM
> To: DOTNET-WEBDISCUSS.DEVELOP.COM
> Subject: Re: [DOTNET-WEB] sql 2k5 db diagram designer
>
> > Btw, is anyone using Visio to model their dbs?  I
used to use it (VEA)
> > a while back, but remember some limitations that
were not "must haves"
> > but more annoyances, so I went back to the just
designing inside  of
> > enterprise mgr.  I have also used embarcadero and
Erwin, but those are
> > out now since I can't afford the licenses.
>
> Haven't used it in anger but, it may work for you. DB
Designer is an open
> source tool:
>
>     http://fabforce.net/
dbdesigner4/
>
>
> Kunle

===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com

I agree on all of your assertions Robert.  Though I wish
someone would come
in to compete with ER/Win feature by feature as an
independent consultant it
is hard to swallow a 4K drop at one time to use ER/Win and
many of my small
clients can't takeover ER/Win diagrams once I am done with
a project, losing
some of the usefulness of using ER/Win for schema lifecycle
maintenance.  If
CA dropped the price to be competitive, I'd be one of their
loudest fanboys.

Thanks,

Shawn Wildermuth
http://adoguy.com
C# MVP, MCSD.NET, Author and Speaker


-----Original Message-----
From: Discussion of building .NET applications targeted for
the Web
[mailtoOTNET-WE
BDISCUSS.DEVELOP.COM] On Behalf Of Robert L. Stewart
Sent: Wednesday, May 17, 2006 7:55 AM
To: DOTNET-WEBDISCUSS.DEVELOP.COM
Subject: Re: [DOTNET-WEB] sql 2k5 db diagram designer

While ERWin is expensive and owned by CA, it is still one of
the best tools
out there.  There is also a tool called Case Studio
(http://www
.casestudio.com/enu/default.aspx) that will do multiple
databases.
I have tested it as a low cost alternative for the SIG that
I am a leader of
in Houston.  It is actually pretty good.  Especially for the
price.  Your DB
Designer says it is designed for MySQL.  So I do not know
how useful it will
be for MS SQL databases.

The SQL Server built in diagramer is mainly good for adding
the
relationships and naming them.

Visio is a joke.

Robert L. Stewart
The Dyson Group International
Software for the Non-profit Enterprise
Expanding your Sphere of Knowledge


Quoting Automatic digest processor <LISTSERVDISCUSS.DEVELOP.COM>:

> Date:    Tue, 16 May 2006 15:15:17 -0400
> From:    Shawn Wildermuth <swildermuth_listsADOGUY.COM>
> Subject: Re: sql 2k5 db diagram designer
>
> I played with DB Designer have you suggested it.  My
$0.02:
>
> - Crashed a lot on me.
> - Reverse engineering was helpful, but no diagram
auto-layout (drops
> diagram in seemingly random order so I have to spend a
lot of time
> deciphering the results).
> - No support for creating "Diff" SQL.  Will
synch with a database, but
> that is rarely what I'd like to do.
>
> I still like ER/Win but two things make me never
recommend it:  Huge
> cost (>4K/developer); Its owned by CA.
>
>
> :p
>
>
>
> Thanks,
>
> Shawn Wildermuth
> http://adoguy.com
> C# MVP, MCSD.NET, Author and Speaker
>
>
> -----Original Message-----
> From: Discussion of building .NET applications targeted
for the Web
> [mailtoOTNET-WE
BDISCUSS.DEVELOP.COM] On Behalf Of Kunle Odutola
> Sent: Sunday, May 14, 2006 4:39 PM
> To: DOTNET-WEBDISCUSS.DEVELOP.COM
> Subject: Re: [DOTNET-WEB] sql 2k5 db diagram designer
>
> > Btw, is anyone using Visio to model their dbs?  I
used to use it
> > (VEA) a while back, but remember some limitations
that were not "must
haves"
> > but more annoyances, so I went back to the just
designing inside  of
> > enterprise mgr.  I have also used embarcadero and
Erwin, but those
> > are out now since I can't afford the licenses.
>
> Haven't used it in anger but, it may work for you. DB
Designer is an
> open source tool:
>
>     http://fabforce.net/
dbdesigner4/
>
>
> Kunle

===================================
This list is hosted by DevelopMentorR  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com


===================================
This list is hosted by DevelopMentorŪ  http://www.develop.com

View archives and manage your subscription(s) at http://discuss.develop.com