Learn more about SQL Server tools

mssqltips logo

Tutorials          DBA          Dev          BI          Career          Categories          Webcasts          Scripts          Today's Tip          Join

Tutorials      DBA      Dev      BI      Categories      Webcasts

DBA    Dev    BI    Categories


SQL Server Data Modeling Tools

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

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.

Below outlines 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 Microsoft's Visio   * *    
6 Quest's Toad™ Data Modeler * * *   *
7 Sybase PowerDesinger * * *    
8 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 [email protected] with the pertinent information.

Last Updated: 2006-10-06

get scripts

next tip button

About the author
MSSQLTips author Jeremy Kadlec Since 2002, Jeremy Kadlec has delivered value to the global SQL Server community as an MSSQLTips.com co-founder and Edgewood Solutions SQL Server Consultant.

View all my tips

Post a comment or let the author know this tip helped.

All comments are reviewed, so stay on subject or we may delete your comment. Note: your email address is not published. Required fields are marked with an asterisk (*).

*Name    *Email    Email me updates 

Signup for our newsletter
 I agree by submitting my data to receive communications, account updates and/or special offers about SQL Server from MSSQLTips and/or its Sponsors. I have read the privacy statement and understand I may unsubscribe at any time.


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


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

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.

Learn more about SQL Server tools