Datatable design view for Azure SQL Database
Scope
This article has the goal to show a way to explore an Azure SQL Database, in especial the datatable design view.
Introduction
Microsoft SQL Server Management Studio is a great tool for management our databases, but for how is using Azure SQL Database there is an “issue” we find in the first time we try to explorer the database. When we try to see a table in design mode we cannot do it, only is possible to use SQL script, what can be a slow process for how don´t have so much experience with SQL.
Solution
Visual Studio 2013 allow to explore SQL database and has feature for show de design view.
Let’s see how it works for show an Azure SQL Database.
First in Server explorer, we need to connect to Azure account and then selecting the SQL Database we should click in “Open SQL Server Object Explorer” like we can see in the follow image:
http://i2.wp.com/s9.postimg.org/ybbrc75hb/open_explorer.png?w=584
After this, will be show a popup to connect to the database (you maybe need to set your IP in Azure Firewall)
http://i0.wp.com/s21.postimg.org/qe5tm52mf/Login.png?resize=584%2C320
Now we are connected to the Azure SQL Database:
http://i2.wp.com/s30.postimg.org/y5mru5s3l/Explorer.png?resize=472%2C371
This sample uses a free database with two scheme (dbo and testforblob).
Now we are available to see the data and see the table in design view, for it we should use the context menu:
http://i1.wp.com/s1.postimg.org/krftwjwe7/View_Design_Data.png?w=584
The result of “View Designer” is:
http://i0.wp.com/s29.postimg.org/jz6is1axz/design.png?resize=584%2C344
In this view we can edit the table definition using design view.
And the result of “View Data” is
http://i2.wp.com/s15.postimg.org/4j4g4g78r/data.png?resize=584%2C272
In this view we can change the data about orders that is a quickly way for it, without SQL.
Conclusion
In conclusion, Visual Studio 2013 has a great mode to explorer database and allow to have design view for Azure SQL Database what is very useful for management databases. And the other great thing is I not need to have Microsoft SQL Server Management Studio installed in our machine (at least for simple and basic task!)