Geek Answers Handbook

Azure table designer

I have an Azure test site and am trying to connect it to an Azure SQL database. I used the Azure portal to create a new database. Since the database was successfully created, I opened SSMS 2012 and connected to the server and the database. I expected that I could create new tables, etc. Via SSMS, using the standard Create Table graphical interface (one that allows you to enter a column name, identifier, data type, etc. In a grid format), but SSMS 2012 does not look like having a table design window. Am I missing something? Is there an OOB release for this? I am running VS 2012 Ultimate, SSMS 2012, and I already have the VS2012 Azure SDK.

+4
source share
2 answers

Why not use the online portal? The same portal that you used to create the database allows you to create tables using the grid format as you describe. Just click the "Design" button in the lower left, and then click "Create Table" below and away. You can also create indexes, foreign keys, etc.

+2
source

I think you should take a look at the SQL Server Data Tool (SSDT), which should be included in SQL Server 2012. Not sure if it is included in Express, but after installing SQL 2012 you will find a new window in Visual Studio 2012 where you can Create your own Azure SQL database in a graphical interface.

I have a blog about this feature, but I think it was easier to install and use. http://blogs.shaunxu.me/archive/2012/04/28/ssdt-ndash-makes-sql-azure-development-easy.aspx

+2
source

More articles:


All Articles