Post reply

sql server reverse engineering

  • April 8, 2009 at 4:21 am

    #129784

    Hi,

    i have a database from which i want to autocreate a datamodel in sql server 2005 the supplier won't give us the datamodel. does anyone know how to fast reverse engineer the database so that it automatically generates a datamodel of my database.

    thanks,

    Bryan

  • April 8, 2009 at 5:25 am

    #974165

    by data mmodel you mean a diagram, where all the tables are shown with likes representing foreign keys?

    if you have the database, the schema is wide open for you to use any tool to use to make a diagram.

    the built in ine from SSMS is your first choice,,,,

    open object explorer, find the database yyou want to diagram

    expand the folder, and you will get prompted with this dialog

    This database does not have one or more of the support objects required to use database diagramming.

    Do you wish to create them?

    from there you can make multiple diagrams, typically by selecting an tablea and allowing the app will add the lines for any dependencies;

    then you can arrange them in a better order than the default design does.

    it's the same for any third party designers as well.

    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!

  • April 8, 2009 at 5:29 am

    #974167

    Hi Lowell,

    just got it working with visio 2007. thanks in advance for you advise.

    bryan

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

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