SQL Server Data Modeling Tools


By:   |   Updated: 2006-10-06   |   Comments (2)   |   Related: More > Database Design


Building Better Data Models

Free MSSQLTips Webinar: Building Better Data Models

Learn how to build data models from concept to actual model and what you should know when building a model. We will also look at how to take the logical model to the physical model to be implemented in SQL Server.


Problem

With the recent tip on the native SQL Server data modeling capabilities, questions arose about data modeling alternatives in the marketplace.  The native tools are a very valuable free solution, but may lack advanced functionality needed in some circumstances.  As such, this tip outlines the data modeling tools available for SQL Server which can be leveraged by DBAs and Developers to meet a variety of data modeling needs.

Solution

Below outlines some the SQL Server data modeling tools in the market place: 

ID Product Multi Platforms Reverse Engineering Forward Engineering Auto Object Generation Data Dictionary
1 Chilli Source's Database Design Studio * * * *  
2 Computer Associate's AllFusion® ERwin® Data Modeler * * * *  
3 Datanamic's DeZign * * *   *
4 Embarcadero's ER/Studio * * *
5 ERBuilder Data Modeler * * *   *
6 Microsoft's Visio   * *    
7 Quest's Toad™ Data Modeler * * *   *
8 Sybase PowerDesinger * * *    
9 XCase * * *    
Next Steps
  • Evaluate your current data modeling needs to determine if the native tool set will support your efforts.
  • If the native tool set does not meet your needs, review the tools listed about and consider evaluating 1 or more of these tools.  Most of the vendors offer a trial version of their software which can be tested to ensure it meets your needs.
  • If you have worked with other SQL Server data modeling tools, please let us know by sending an email to tips@mssqltips.com with the pertinent information.





get scripts

next tip button



About the author
MSSQLTips author Jeremy Kadlec Jeremy Kadlec is the Co-Founder, Editor and Author at MSSQLTips.com, CTO @ Edgewood Solutions and a six time SQL Server MVP.

View all my tips


Article Last Updated: 2006-10-06

Comments For This Article




Monday, July 25, 2011 - 7:54:07 AM - Jeremy Kadlec Back To Top (14256)

Robert,

Good morning.  You are correct.  We need to get this tip updated.

Thank you,
Jeremy Kadlec


Tuesday, March 15, 2011 - 8:54:57 AM - Robert Back To Top (13216)

Unfortunately, your #1 on the list does not exist any more.  Chili Sfot has a one page web site with broken link to the 3 links to their products.



download














get free sql tips
agree to terms