Post reply

Microsoft Visio ERD Diagrams

  • March 14, 2007 at 7:29 pm

    #172818

    I know that if I create a visio erd diagram and can export it to sql server and it will create a database based on the diagram with the tables, keys and relationships created. 

    However, I am creating a new erd diagram that has many tables that won't fit into the largest page. 

    My question is: can I break up the diagram into several pages? To continue the links between the pages, I might have to repeat some tables on the other pages.  Will this interfere by creating duplicate tables from the repeating table? Or will it create other instances of the repeating tables from the diagram?  And is it ok if other instances are created?

    If I can't repeat the tables, is there a way in visio to show the link of a table with tables on another page?

    Thanks Much for any ideas, suggestions, or answers.

  • March 15, 2007 at 5:15 am

    #695178

    yes, and that's exactly what we do in our shop...we make multiple ERD's, each related to following a specific flow of data...one for product and it's attributes, another for orders that relates to products (but not it's detail), another for billing as related to orders, etc. we probably have 20 different ERD's explaining the different business logic of the data.

    You can use the same table in multiple ERD's no problem...if you get in a psoition where you feel you need to repeat a table, that's where you might want to pull out a group of tables as a separate ERD, to better visually depect the detail of the relationships

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • March 15, 2007 at 11:35 am

    #695310

    Thanks for your info.  You have been a great help.

  • March 15, 2007 at 12:30 pm

    #695322

    "I am creating a new erd diagram that has many tables that won't fit into the largest page."

    Don't overlook the low-tech solution:  I only have an 8-1/2 by 11 inch printer, so I print the diagram and scotch-tape the pages together.

    There is no "i" in team, but idiot has two.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply