"DBA Infopower Support" <su*****@dbainfopower.com> writes:
Hello Grace,
You can try ERWIN by CA and ER-Studio by embarcadero. Both products
support multiple database (like Oracle, DB2, SQL-Server, etc).
ERWIN has more options, but more expensive as well. ER-Studio is a good
tool. Both tools can convert local Entity-Relationship diagrams (models) to
physical schemas for required database type and can reverse-engineer
physical schema to logical ERD as well.
When I looked at embarcadero er-studio, it did not support relationships
between 3 or more entities. Since I consider this a mandatory requirement,
I have not considered it a usable tool. Have they upgraded this aspect of
the tool?
As an aside, I also don't like the way Embarcadero markets their products.
if you buy one, they send you a CD with the entire suite. When I installed
one of their products, I, unknowingly, installed a tool that was not part of
the subset of the suite my employer had purchased, and when I did the
process to request a key to use the part that was purchased for more than
30 days, it also generated a request for the tool that wasn't purchased,
which led to one of their rabid dog marketing folks doing cold calls to me
to try to convince me to buy it. When the person would not take no for an
answer, I eventually said something like, "Look, this product is worthless,
and I'm not interested." This led to the person phoning my boss to say I
was being uncooperative and tactless or some such. So I personally won't
have anything to do with Embarcardero or their tools if I have any say in
the matter, but this is a different issue from whether one of their products
might meet your needs.
Cheers,
Joseph