3

I have a database which has almost 300 tables, I've just come across with a problem that I've added almost 60 tables into my diagram. I can only view the entire page if I set the page zoom to %10 and it's not really useful. Anyone has any suggestions for the problem? I need to view the diagram which is able to view more useful way. If the suggestion will be one of the SQL Server 2008 built-in features I'd appreciate. Thanks.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Fırat Tuncer
  • 85
  • 2
  • 6

3 Answers3

5

For this situation I build several diagrams, each with logical subsets of tables. It is going to be easier to understand the schema with that many tables if you break it up.

On the other hand, if you are looking for the "wall of schema" and just want to make a big poster to impress people, I would use Visio to reverse engineer the schema. It provides a lot more options in terms of how the tables get layed out.

D'Arcy Rittich
  • 167,292
  • 40
  • 290
  • 283
  • Visio suggestion is really useful. – Denis Valeev Sep 21 '10 at 15:19
  • "...and just want to make a big poster impress people". Really? I personally think these are very helpful. Almost like having a 3rd monitor if you're doing something that requires you to see the db diagram... – Abe Miessler Sep 21 '10 at 15:22
  • I'm with red filter on this ... trying to put 300 tables into a single ERD looks like a wiring diagram with all the cross overs. Break out the diagrams into logical groupings. – StuartLC Sep 21 '10 at 15:38
  • @Firat: I believe this requires the Professional edition (at least for the 2007 version). – D'Arcy Rittich Sep 21 '10 at 15:41
  • 1
    I would suggest Erwin, Embarcadero or Sparks Enterprise Architect instead of MS Visio. – juur Sep 21 '10 at 17:15
  • @juur: can you qualify how those options are better? – D'Arcy Rittich Sep 21 '10 at 17:31
  • Those are real modeling tools, much more versatile compared to MS Visio. I use Sparks EA and MS Visio constantly, but prefer the former. – juur Sep 21 '10 at 17:44
  • @juur: How are they better specifically with regards to diagram layout, which is the OP's question? – D'Arcy Rittich Sep 21 '10 at 17:53
  • Its better, believe me, e.g. Sparks EA can reveal cardinalities much more visually and show Primary and foreign keys much more clearer that Visio. – juur Sep 21 '10 at 18:06
2

You can copy the whole diagram at zoom 100% and paste it as bitmap in any of your favorite image editors for further perusal. :)

Denis Valeev
  • 5,975
  • 35
  • 41
  • I've tried it before but during the paste step an error occured, I think it was a kind of memory problem which my laptop can not handle with it. – Fırat Tuncer Sep 21 '10 at 15:44
  • 1
    @Firat Tuncer don't try to paste it to MS Paint, though. :) Try to use http://www.paint.net/ for example. – Denis Valeev Sep 21 '10 at 15:50
1

create your diagrams that focus on a certain portion of your database.

create a new diagram, add only the existing tables to it for a certain area: orders, patients, etc. don't try to have an all inclusive diagram, unless you want to view small portions of it at one time.

KM.
  • 101,727
  • 34
  • 178
  • 212