Post reply

Generate data models of all databases

  • February 12, 2015 at 9:16 am

    #301247

    Hi guys,

    I need to generate data models of all databases for an instance. How can I accomplish this?

    If anyone has done this before please share your thoughts.

    Thanks!

  • February 12, 2015 at 9:36 am

    #1777287

    what is a data model to you?

    there's tons of example scripts of database documentation,scripting out object definitions, basic counts and stats, how to create diagrams, etc, but "data model" is a loose term than means different things to different people.

    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!

  • February 12, 2015 at 9:47 am

    #1777290

    SQL!$@w$0ME (2/12/2015)

    Hi guys,

    I need to generate data models of all databases for an instance. How can I accomplish this?

    If anyone has done this before please share your thoughts.

    Thanks!

    Manual labor one by one will git-er-done!

    The SSMS diagrams tool is the most basic ER Diagramming tool I've used. I'd love to see a third party tool, perhaps an SGML based tool, something that can batch print diagrams or convert to PDF. Customers are always asking for ER diagrams and it takes an hour for a salesman to print 40 diagrams to PDF manually.

  • February 12, 2015 at 9:52 am

    #1777291

    Database Documentation listing the objects in the database and their relations.

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

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