Data Modeling Tool that Reverse Engineers an existing database

  • I'm looking for a tool that will reverse engineer an existing database into a data model. I know that Erwin will do this and I believe MS Visio can as well, but, thought there might be others out there that I'm not aware of. Hopefully they have a trial period for me to evaluate.

    Thanks in advance

  • I think most modelling tools can do this. I have worked with ERStudio from Embarcadero and PowerDesigner from Sybase, both can reverse engineer, though it sometimes comes with weird solutions.

    However, it has been some years I used those, maybe things have improed.

    HtH.

    Greetz,
    Hans Brouwer

  • Erwin and ERStudio are the favorites , Ive seen them in almost every company I worked for. Visio is good but the newer version will not create a database from the new model. There is a plugin for visio available but its not an official MS product.

    Jayanth Kurup[/url]

  • Another vote for ERStudio from Embarcadero. Excellent piece of software.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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