diagramming a database

[pzz76077]

You could also try this add in from Microsoft that seems to do a lot of what you want dynamically:

"This add-in takes the input of SQL configuration prerequisites from users for SQL Server installations and shows them in a clear, easy to read diagram"

http://www.microsoft.com/downloads/d...kInfoContainer

PZZ

[pzz76077]

If you really want to kill yourself and do this in Visio, you can do what you want by using different layers to hide stuff etc.

You may be able to pick up some more free stuff at http://www.visiocafe.com/ that could save a bit of time.

PZZ

[Olly]

Problem is the free bit... there's plenty of great tools out there, erwin being my fav, otherwise visio is prob the best you got ...

I had a little look at Erwin last time and couldn't see this functionality...does it have it?
Thanks

[Jeebo72]

Problem is the free bit... there's plenty of great tools out there, erwin being my fav, otherwise visio is prob the best you got ...

[Spacecadet]

Hmm...writing functionality that creates a copy and deletes the fields I'm not interested in would work. Extending that to put in "fake" relationship would be another matter and it wouldn't be ideal.

Funnily enough - this is the third organistation I've worked for that have this need....for a way to dynamically simplify and "correct" a database diagram.

viso is not a required tool, it's just that's how it's done now

PM on the way

[Olly]

Hmm...writing functionality that creates a copy and deletes the fields I'm not interested in would work. Extending that to put in "fake" relationship would be another matter and it wouldn't be ideal.

Funnily enough - this is the third organistation I've worked for that have this need....for a way to dynamically simplify and "correct" a database diagram.

viso is not a required tool, it's just that's how it's done now

[AtW]

sp_help is all you should need.

HTH

[Spacecadet]

Doesn't Database diagrams in Management Studio with the Table View set to 'Names only' suit what you want?

I think he wants to do it in visio...

If there is no way to do this in visio then what you could do (as a bit of a hack workaround) is:
Rebuild the tables just for modelling purposes without the columns you want want hiding, then point visio at that.
Of course this then means you have 2 lots of tables to maintain, however it shouldn't be too big a job to write a stored procedure to do this for you

[HairyArsedBloke]

Doesn't Database diagrams in Management Studio with the Table View set to 'Names only' suit what you want?

[Olly]

so no knowledgeable folk able to spare a bit or er....knowledge?

purleaseeee

[DimPrawn]

No idea.

[Olly]

Would help if you said what database system you are using.

Okey doke - SQL server 2005
Though from a bit of a dig a few years ago it seemed most offerings were applicable to all major systems.
Still never found something simple and free enough. Actually found nothing that could do this kind of "overlay" hence the post.

[DimPrawn]

Would help if you said what database system you are using.

[Olly]

Currently done via Viso.
I'd like to hide fields that aren't relevant or being used but be able to keep the diagram up to date by refreshing against the server.

Essentially an overlay of rules that hide fields and force relationships.

Please does anyone know of something out there, more free the better, that could do the trick.

Ta