Re: Suggested DB Reverse Engineering tool...

Vikas Rajput (vikasrajp@xxxxxxxxx) writes:
We have a SQL Server 2000 based system which carries 1000+ DBs
primarily setup as:
1 security DB,
1 transaction management DB,
1 message support DB, and
many many development DBs (as a suite of 3 DBs)

Now, one thing missing is the Data Model. :-)
Am slightly new to this area and what am looking for is some Open
Source/freeware tool/utility which can read through the DBs (dont mind
if it does one DB at a time) and get some ligitemate DB Model
(physical/logical) out. I have heard of MSVisio (with some APIs
probably) but havent got chance to put my hands on it. DBDesigner4 is
an option but it creates plain report with table and columns with no
depiction for relations etc. Any help is much appreciated..

If you want a full-blown data-modelling tool, the prime competitors
on the market are PowerDesigner (from Sybase), ERWin (from Computer
Associates) and Embrocadero. But open source and freeware they are
not. I only know about the pricing for PowerDesigner, and it's certainly
expensive, least of all if you only want support for physical data
modelling. (The price includes a bunch of other types of models.)

Red Gate has SQLDoc which also has a price tag, but a lot smaller than
PowerDesigner. But this is not a modelling tool, and may not give
you that much more than DBDesigner4 does (I'm not acquainted with
DBDesigner4.)

ApexSQL has a tool similar to Red Gate's, Apex SQLDoc.


--
Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
.

Relevant Pages

  • Re: public role???
    ... account existed for all these DBs. ... these users from viewing the master and tempdb DBs as well? ... then that's the way SQL Server ... >see if you have the "guest" account enabled in the other ...
    (microsoft.public.sqlserver.security)
  • Re: public role???
    ... What exactly do you mean by "new users have access to all DBs"? ... If you mean that new users can see the names of the other databases, ... Documentation on the "guest" account is available in the SQL Server Books ... > permissions. ...
    (microsoft.public.sqlserver.security)
  • Q: Open-source to access MS SQL server 2000/2005 DBs from Ada ?
    ... What do you recommend as an open-source, reliable package (or set ... of packages) to access MS SQL server 2000/2005 DBs (hopefully these ... The Ada code would steer DBs through simple SQL queries. ...
    (comp.lang.ada)
  • Re: User komplett entfernen?
    ... > erstmal von allen DBs entfernen - falls ja, gibt es einen Weg, ... so einen Befehl gibt es nicht. ... Wenn Du den User aus dem SQL Server löscht, ist er in der DB immer noch ... den User vom SQL Server löschen - sp_droplogin ...
    (microsoft.public.de.sqlserver)
  • Re: How to create an admin with some limitations?
    ... Until today i was the only admin of all dbs. ... Now i need to give to another admin permission to manage one specific ... also db where this login is not autorized. ... Erland Sommarskog, SQL Server MVP, esquel@xxxxxxxxxxxxx ...
    (comp.databases.ms-sqlserver)