Hi,
We have a SQL Server 2000 based system which carries 1000+ DBs
primarily setup as:
1 security DB,
1 transaction management DB,
1 message sup****t 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 re****t with table and columns with no
depiction for relations etc. Any help is much appreciated..
