GUI for creating Azure Database Tables [closed]

Question

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

Unfortunately it does not seem possible any longer to do this for an SQL Azure Database, "feature not supported". Does anybody know of a GUI based tool for creating and modifying data table schemas? I could obviously script these changes but it's so much quicker with a GUI.

Does Visual Studio 2012 support this?

Answer 1

Yes, the Server Explorer of Visual Studio 2012 supports connections to SQL Azure Databse 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 designer in the SQL Server Management Portal.

Edit:

I see you would like to have a designer UI. There's no such feature in SSMS as far as I know but Visual Studio 2012 does support this feature. If you don't want to switch to VS2012 you still can user the UI from the SQL Azure Management portal.

• Visual Studio 2012
• SQL Azure Management Portal

Answer 2

How about the SSDT (SQL Server Data Tool) which shipped along with SQL Server 2012 and integrated with VS2012. It support GUI 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