Re: Database design tools - which do you like and what criteria do you use [SQL Editor]
- From: "metaperl" <metaperl@xxxxxxxxx>
- Date: 1 Sep 2006 00:29:37 -0700
metaperl wrote:
I've been running about the internet like a chicken with my head cutSo far SQL Editor looks best
off looking for my dream database tool and most have come up short in
one way or the other.
Factors in Evaluating a Database Design Tool
============================================
General
-------
* What platforms does it run on
only OS X! that's bad. That's why I left datanamic dezign - I was a PC
user and now I am a mac user... why should I have to switch tools
* What databases does it work with
MySQL, Sybase, Postgres, Oracle
* Is it primarily a physical or logical database design tool?
logical
* Support - email, phone, chat. What is the cost
free once you buy the product. email and phone
* Cost - what is the cost of the product? And upgrades.
A very reasonable 69.00
* Documentation - HTML, PDF, PNG?
JPEG, PNG
Interactive Design (Forward Engineering)
----------------------------------------
* Can the entity boxes be sized smaller than the number of attributes
and made scrollable? The only thing I have seen with this ability is
`SyBrowser
<http://www.macsos.com.au/shareware/sybrowser/SyBrowser.html>`_
I dont think so
* Does it come with a sample database
No
* Does it automatically create intermediate tables for many to many
relationships?
No! It let me create a many to many relationship but did not make the
intermediate table in the generated SQL!! That means I have to manually
create the table!!!
* Does it generate SQL for DDL deltas? Or does it only generate SQL
for the entire schema? Are arbitrarily deep backward and forward
deltas possible?
None of this appears possible.
* Foreign key - does it support ON DELETE and ON UPDATE functionality
only ON DELETE
* Sibling fields - what is this anyway?
The manual did not describe this and I don't know what the heck it
is... yet it is was in the options for attribute design
Reverse Engineering
-------------------
* Can it reverse engineer a database design by parsing a SQL file or
directly connecting to a database
Don't think so
Products
========
* `DbWrench <http://www.dbwrench.com/>`_
good product, but no response to my email query to them. they don't
really seem to be alive
* `dbSketch <http://codercentric.com/>`_
new product. physical design. java based so multi-platform .responsive
customer support.
* `SyBrowser
<http://www.macsos.com.au/shareware/sybrowser/SyBrowser.html>`_
demo is horribly limiting. really could get no idea of how good it is
via demo. It does look nice and it has been around a long time and it
does run on all platforms. It does seem like a slightly more featureful
product than SQL Editor, but again, why should I pay money for
something I have not been able to try thoroughly? Anyone can make a
nice webpage, but without trying out the software I could come out
empty-handed.
* `SQL Editor <http://www.malcolmhardie.com/sqleditor/cocoa/>`_
Nice simple straightforward package. Really should have support for
automatic creation of many to many jons.
* `DeZign <http://www.datanamic.com>`_
Was a great product when I was a windows user. Very good customer
support. Very nice product. I was a version 3 user. Version 4 looks
even nicer.
.
- References:
- Prev by Date: Database design tools - which do you like and what criteria do you use
- Next by Date: Re: Database design tools - which do you like and what criteria do you use
- Previous by thread: Database design tools - which do you like and what criteria do you use
- Next by thread: Re: Database design tools - which do you like and what criteria do you use
- Index(es):
Relevant Pages
|
