Geek Answers Handbook

GUI for creating Azure database tables

Before moving on to Azure, I used to create and modify data tables for my database in Visual Studio 2010 directly from Server Explorer ( Add New Table / Open Table Definition ).

Unfortunately, for the Azure SQL Database this is no longer possible, "feature is not supported." Does anyone know a GUI based tool for creating and modifying data table schemas? I could explicitly script to make these changes, but it is much faster with a GUI.

Does Visual Studio 2012 support this?

+4
source share
2 answers

Yes, Visual Studio 2012 Server Explorer supports connections to Azure Databse SQL Servers. But you can also use the free SQL Server Express Management Studio 2008 R2 (or newer) to connect to SQL Azure, or even use the constructor in SQL Server Management Portal.

Edit:

I see that you would like to have a design interface. There is no such possibility in SSMS as far as I know, but Visual Studio 2012 supports this feature. If you do not want to switch to VS2012, you can still use the user interface on the SQL database management portal.

  • Visual studio 2012 Database Designer for SQL Azure from VS2012
  • Azure SQL Management Portal enter image description here
+14
source

What about the SSDT (SQL Server Data Tool), which comes with SQL Server 2012 and is integrated with VS2012. It supports a graphical interface for SQL Server as well as SQL Azure.

http://msdn.microsoft.com/en-us/data/tools.aspx

http://blogs.shaunxu.me/archive/2012/04/28/ssdt-ndash-makes-sql-azure-development-easy.aspx

+4
source

More articles:


All Articles