Create Database Diagrams of Your Windows Azure SQL Databases

October 26, 2013 — 5 Comments

Do you miss Database Diagrams?

I find them to be indispensable when I join new projects, because they provide insight that makes my on-boarding much smoother.

As my databases are hosted on the Windows Azure SQL Database Service, I am not able to create Database Diagrams using tools like Microsoft SQL Server Management Studio or Visual Studio 2013. Finding this to be a pain, I decided to look around for tools that were able to create Database Diagrams.

Of course my first reflex at that time, was to generate an EDMX using Entity Framework and Visual Studio. This was an ok solution for short glimpse of the database. The EDMX is great at helping me grasp the data model, but it hides a few important details.

Then with a bit creativity I started throwing queries at Bing and found a few tools. The one I decided to test was dbForge Studio for SQL Server. With it, I started creating Database Diagrams in minutes. Tables are arranged so that it’s easy to grasp meaning from the diagrams.

 

A few weeks in, I started using dbForge Studio for SQL Server to write test queries and stored procedures. To my surprise the tool has some really nice features. For starters, the code completion functionality is really useful. It helped me discover column names and relations as I typed my queries. Furthermore, it helped standardize my scripts by formatting statements as I typed them.

10-26-2013 1-53-23 PM

As you may already know, I’m a big fan of using the Microsoft SQL Server Data Tools. Teaming these tools together was a natural reflex that enabled me to work effectively with Windows Azure SQL Database.

Reasons Why I Like dbForge Studio for SQL Server

  • Has really good coding support like code completion and code formatting that help enforce coding standards (priceless when it comes to collaboration work)
  • It’s easy to use and helps enforce best practices like creating indexes on Foreign Keys
  • It’s able to create diagrams from Database hosted on Windows Azure SQL Database

Reasons Why I Like Microsoft SQL Server Data Tools

  • Has IntelliSense
  • Statically validates SQL statements against targeted platforms like Windows Azure SQL Database
  • Make it possible to manage database versions by storing scripts in TFS
  • Facilitates deployments

Wrapping things up

In a post about Windows Azure SQL Database Application Life Cycle Management Made Easy! I wrote about how I use the Microsoft SQL Server Data Tools in order to allow teams to collaborate on database development.

Since then I started using dbForge Studio for SQL Server as a Dev & Test tool. Its tooling allows me to create Database Diagrams for Windows Azure SQL Databases and it boosted my productivity by helping me write SQL statement faster. To me it felt like R# for SQL =)

Both are now on my Windows Azure tool belt. Do you have any tools that help you develop more effectively on Windows Azure?

About these ads

Trackbacks and Pingbacks:

  1. Dew Drop – October 28, 2013 (#1,654) | Morning Dew - October 28, 2013

    […] Create Database Diagrams of Your Windows Azure SQL Databases (Alexandre Brisebois) […]

    Like this

  2. Reading Notes 2013-11-04 | Matricis - November 4, 2013

    […] Create Database Diagrams of Your Windows Azure SQL Databases – Really? I though it was possible to connect with sql manager and make a diagram. I must try the dbforge tool, looks pretty slick. […]

    Like this

  3. Windows Azure Community News Roundup #75 - Windows Azure Blog - November 4, 2013

    […] Create Database Diagrams of Your Windows Azure SQL Databases (posted October 26th) […]

    Like this

  4. 微软云计算: Windows Azure 中文博客 - November 6, 2013

    Windows Azure 社区新闻综述(#75 版)

    欢迎查看最新版本的每周综述,其中包含有关云计算和 Windows Azure 的社区推动新闻、内容和对话。以下是本周的亮点。 文章、视频和博客文章 PowerShell 对 Windows

    Like this

  5. Episode 4 - Storage - November 6, 2013

    […] http://alexandrebrisebois.wordpress.com/2013/10/26/create-database-diagrams-of-your-windows-azure-sq… […]

    Like this

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s