Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
morticia
Starting Member
1 Post |
 Posted - 2004-12-02 : 16:26:28
|
| I'm using Visio to reverse engineer several SQL databases for audit documentation purposes. I've had no difficulty creating a lovely MS Word document with all the info I need for each DB. What I don't get is how to generate a full schema diagram for each DB. Help says select and drag the tables to the diagram page. There are so many tables, however, that the resulting diagram is HUGE. If I only drag a few to make a multi-page schema map, I loose the relationships. Any suggestions, seasoned pros? |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-12-02 : 16:32:53
|
| Change the font, change the paper size, or change the scale. We use ANSI E paper for out drawing size. I think that's 34 by 44 inches. We use a plotter printer to print it.Tara |
 |
|
|
sherrys
Starting Member
37 Posts |
Posted - 2004-12-02 : 16:45:31
|
| Insert new pages to your visio diagram. Divide up you database into logical business units. Put each business unit on one page. Make a main page of your diagram showing only the tables that are related to tables in other business units. |
|
|
|
|
|
|
Generate schema diagram with Visio