Analyzing tables/data

[Olavxxx]

Hi,

I hope this is the correct forum for my question.

Before I ask it, here is what I want to do:
I want to analyze and visualize tables, some fields (Primary Key, Foreign key) and understand data of tables.

Then I would like this in a visual way, maybe grouped by color. I know this means a third party application most likely.

The thing is that we have to archive old data systems and now we got an sql db with 50+ tables and it will take a lot of time to manually draw up boxes.

So, my question:
Is there an application that can do this, eg. analyze and document the structure and fields, in a human-logical way?

Preferrably a cheap or free app, seeing as we are a non profit organization.

Olav Alexander Mjelde

 

[Crowley16]

probably not the right forum, maybe sql server: programming may be better...

however, have you had a look at setting up a database diagram and adding every table? You'll need standard edition or above.

in management studio, object explorer, expand to the database you want, there should be a Database Diagrams tab. If you right click, and add a new diagram, then right click and add tables, and add all tables, it'll draw you a picture of all tables/columns/links.

doesn't have colour though.

--------------------
Procrastinate Now!