Schema/Table Relationship Tool

Last Post 29 Mar 2005 07:56 AM by snakoil. 3 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
New Member
New Member

16 Mar 2005 06:03 AM

I've started a new job and I am looking for a tool that will go out and search existing databases and create a logical map and show me the relationships between the various tables.

It's always challenging coming into a new job and trying to grasp relational relationships that someone else has created.

Any advice would be appreciated.

New Member
New Member

17 Mar 2005 11:00 PM
Don't know ERwin, but Visio gets you where you want, I think...

If you use diagram in EM, be sure to not change the tables (add constraints etc.)....(another reason I'd use a separate tool like Visio)
New Member
New Member

29 Mar 2005 07:56 AM
I use Case great and compatible with other database types

can generate shemas, html reports of the DB structure and the inverse...define a schema and generate a comprehensive SQL Server Script to create the DB.

I didn't liked that much ERWin...kind of too heavy to laod and everything...
Case Studio is really light and intuitive!
New Member
New Member

11 Jun 2005 05:35 PM
You can use the diagramming tool. Built in. Missing relationships? You fill in the holes.

Great way to learn the db of the new job.

Kalman Toth, SQL Guru

Acceptable Use Policy