Results 1 to 2 of 2
  1. #1
    3 Star Lounger
    Join Date
    Apr 2002
    Location
    Texas, USA
    Posts
    208
    Thanks
    0
    Thanked 1 Time in 1 Post

    How to generate Relational DB Outine (2003/2007)

    I'm trying to figure out how to generate a ERD like diagram in Visio for a SQL Server DB. I've been thru the various tabs and toolbars in Visio and darned if I can find any shapes for creating Tables, Stored Procedures, Views and so on, all DB specific objects. It would b great if there a plugin/addin for Visio that would automatically create a DDF (Data Dictonary file) from an existing SQL Server DB. And and all help with this is most appreciated.

    Ed

  2. #2
    Super Moderator
    Join Date
    Jan 2001
    Location
    Melbourne, Victoria, Australia
    Posts
    3,852
    Thanks
    4
    Thanked 259 Times in 239 Posts

    Re: How to generate Relational DB Outine (2003/2007)

    The database tools and capabilities in Visio depend heavily on the version you are using. Visio Standard is at the bottom of the tree and the real db functionality is provided in the more expensive versions. Here are some links to give you something to research to solve your issues.

    Microsoft's Visio Editions Comparison
    Database Modelling with Visio
    Designing a Database with Microsoft Visio 2000
    Andrew Lockton, Chrysalis Design, Melbourne Australia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •