CODEWITHSUNDEEP
sql-serverazuressmsazure-sql-database
Dominic St-Pierre
Dominic St-Pierre

Reputation: 2459

Azure SQL - No more manage tool via portal and SSMS 2016 has no table designer

- For the down voter: This is not a rant in anyway, been using Azure since last 4 years, totally fan -

So far I was using the Manage option of the previous Azure portal, now that the new portal is enabled by default, they does not seems to have transferred the Azure SQL manage option.

SQL Server Management Studio 2016 CTP 3.1 (November 2015) does not offer me any kind of table designer.

Now I know, I could type everything into T-SQL, but still for schema manipulation, the table designer is still the quickest.

Is there not any way to have the old "manage" Silverlight interface or having SSMS handling table design with indexes etc?

In fact, I'm reading everywhere that since SSMS 2014 there has been support to Azure SQL table designer, still I don't have that option on the latest version of SSMS. Is the 2016 have less support for Azure SQL than 2014?

I don't have Visual Studio anymore, and frankly I would rather not want to install this just to have a more comfortable time designing a Azure SQL schema.

Any pointer, how do you handle this?

Upvotes: 3

Views: 375

Answers (1)

Benjamin Talmard
Benjamin Talmard

Reputation: 1820

Table Designer for Azure SQL Database V12 has been enabled from SQL Server Management Studio June 2015 Release. Source : http://blogs.msdn.com/b/sqlreleaseservices/archive/2015/06/24/sql-server-management-studio-june-2015-release.aspx

You're saying that you're using the last SSMS version (November 2015) but are you using a V12 server on Azure?

Regards,

Upvotes: 4

Related Questions