Loading...

Tech Talk Live Blog

Database Diagramming

Greg Hess


In application development it is often helpful to visualize your database structure.  This is useful for existing databases to make sure you have all the relationships defined correctly, and especially for new projects as you are building the database.  I recently needed to dive back into database diagramming, so I opened Visio Professional 2016 … and found the database tools had been taken out of that version.  (From my research it appears those features are in, or coming to, the Office 365 edition of the tool, which I do not have.)  This got me looking for a good database diagramming tool that did not break the bank.

My main requirement was the ability to point to an existing database and generate a diagram (reverse engineering), and to generate the database from a diagram (forward engineering).  The databases I am working with are on Microsoft SQL Server, so the tool would need to be able to support that platform.  I also wanted a tool that was easy to use and currently supported.

After some initial research I had two very promising candidates that met my requirements:

SQL Server Database Modeler

This is an online only tool that allows you to create your database diagrams within the browser.  It is still in beta, but from my testing it works quite well.  There is a forward engineering feature which allows you to generate a SQL script to define the database.  The reverse engineering feature gives you a script to run on your current database which generates XML.  You then paste the resulting XML code into the program and it creates a model of your database.  Saving models requires an account, which is free at the time of this blog post.

Screen Shot of SQL Server Database Modeler Interface

DbSchema Diagram Designer and Admin Tool

This is a program that you install on your Windows, Linux, or Mac computer.  It can be used in online or offline mode.  Online mode is when the changes are made directly to the database as you make them.  It supports many relational and NoSQL databases.  It can reverse engineer databases and can save any changes you make back to the database.  An interesting note on this, it has a Schema Synchronization feature which does a compare against what you have in the project and the database, and you can update either side with any changes.

This software has many additional features as well.  It includes a relational data browser, where you can select a value in one table and it will automatically filter a related table to only show rows that match the selected value.  You can use it to generate random data for testing.  Diagrams can be exported as HTML5 documentation to share with coworkers.  It also includes a query builder, SQL editor, and several other features you can read about on their website.

The software comes with a 15-day trial.  At the time of this post, perpetual licenses cost between $63 – $197 per user.

Screen Shot of DbSchema Diagram Designer and Admin Tool Interface

Conclusion

There are many more database diagramming tools available at variable levels of cost, licensing models, functionality, and ease of use.  These are two that caught my attention.  I ended up purchasing DbSchema.

Tech Talk Live Blog Comment Guidelines:

One of our main goals at Tech Talk Live is to build a community. It is our hope that this blog can be a forum for discussion around our content. We see commenting as an integral part of this community. It allows everyone to participate, contribute, connect, and share relevant personal experience that adds value to the conversation. Respect counts. We believe you can disagree without being disagreeable. Please refrain from personal attacks, name calling, libel/defamation, hate speech, discriminatory or obscene/profane language, etc. Comments should keep to the topic at hand, and not be promotional or commercial in nature. Please do not link to personal blog posts, websites, or social media accounts that are irrelevant to the conversation. This is considered self-promotion. We welcome links that help further the conversation and reserve the right to delete those we deem unnecessary. The appearance of external links on this site does not constitute official endorsement on behalf of Tech Talk Live or Lancaster-Lebanon Intermediate Unit 13. You are solely responsible for the content that you post – please use your best judgment. We reserve the right to remove posts that do not follow these guidelines.

Leave a Reply

Your email address will not be published. Required fields are marked *

CONTACT

Tech Talk Live is the only conference of its kind in the region specifically designed for IT pros in education.


techtalklive@iu13.org
1020 New Holland Avenue, Lancaster, PA 17601

(717) 606-1770