Missing menu items for Azure SQL tables within SQL Server Management Studio?

Posted by Sid on Server Fault See other posts from Server Fault or by Sid
Published on 2012-10-10T09:06:59Z Indexed on 2012/10/10 9:40 UTC
Read the original article Hit count: 214

Filed under:

Azure

|

mssql-ssms

|

sql-server-2012

I have a table (say Table1) that is replicated via SQL Data Sync Agent across a local SQL Server 2012 as well as an Azure SQL Server (part of Microsoft Azure). Everything about Table1 (schema, table values etc ) is identical to the best of my understanding.

However, when I list and right click Table1 from Microsoft SQL Server Management Studio 2012 (SSMS), I get some very different menu options, even for seemingly basic stuff.

Lets focus only on the 'Design' menu item:

It is visible for Table1 on the local SQL server in SSMS
It is missing for Table1 on Azure SQL via SSMS
It is visible for Table1 (as Open Table Definition) on Azure SQL when reaching it via Visual Studio 2012 (Server Explorer -> Data connections)

This is seen in the screenshots below: enter image description here

Now I use scripts from some real stuff (esp when I need to check in the SQL scripts etc) but this difference concerns me to some extent.

Am I witnessing just a tools artifact in SQL Server Management Studio when connecting to Azure SQL? or is it something more serious about limitations of Azure SQL itself (although, just seeing the Design surface is so basic!)?

© Server Fault or respective owner

Related posts about Azure

Azure Mobile Services: what files does it consist of?

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
Azure Mobile Services is a platform that provides a small set of functionality consisting of authentication, custom data tables, custom API’s, scheduling scripts and push notifications to be used as the back-end of a mobile application or if you want, any application or web site. As described in my… >>> More
Windows Azure: Backup Services Release, Hyper-V Recovery Manager, VM Enhancements, Enhanced Enterprise Management Support

as seen on ASP.net Weblogs - Search for 'ASP.net Weblogs'
This morning we released a huge set of updates to Windows Azure. These new capabilities include: Backup Services: General Availability of Windows Azure Backup Services Hyper-V Recovery Manager: Public preview of Windows Azure Hyper-V Recovery Manager Virtual Machines: Delete Attached… >>> More
Azure - Part 4 - Table Storage Service in Windows Azure

as seen on Geeks with Blogs - Search for 'Geeks with Blogs'
In Windows Azure platform there are 3 storage we can use to save our data on the cloud. They are the Table, Blob and Queue. Before the Chinese New Year Microsoft announced that Azure SDK 1.1 had been released and it supports a new type of storage – Drive, which allows us to operate NTFS files on the… >>> More
Azure - Unable To Get SQL Azure Invitation Code!

as seen on Stack Overflow - Search for 'Stack Overflow'
Scenario I'm trying to convert my Silverlight Business Application over to the cloud with the help of Azure. I have been following this link from Brad Abrams blog. Both the links to Windows Azure and SQL Azure crash out in Google Chrome, they work in Internet Explorer, but it's literally one of… >>> More
PowerShell Script to Deploy Multiple VM on Azure in Parallel #azure #powershell

as seen on SQL Blog - Search for 'SQL Blog'
This blog is usually dedicated to Business Intelligence and SQL Server, but I didn’t found easily on the web simple PowerShell scripts to help me deploying a number of virtual machines on Azure that I use for testing and development. Since I need to deploy, start, stop and remove many virtual machines… >>> More

Related posts about mssql-ssms

Error when trying to open SQL Maintenance Plan - SSMS 2008

as seen on Server Fault - Search for 'Server Fault'
If I open SSMS on my client machine, connect to our SQL server, and try and open a maintenance plan on there, I get this error: TITLE: Microsoft SQL Server Management Studio Could not load file or assembly 'msddsp, Version=9.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a'… >>> More
SQL Server Management Studio not scripting all objects

as seen on Server Fault - Search for 'Server Fault'
i've been attempting to script a database using SQL Server 2005 Management Studio. i cannot get it to script some objects. It scripts others, but skips some. i can provide detailed screen shots the options being selected including all tables the folder where the script files will go the folder… >>> More
SQL Server 2008 R2 and copy-only default value in SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
We are using Tivoli Storage Manager for taking backups of the database but sometimes our consultants need to take separate backup copies of the database using Management Studio. If they forget to mark the "copy-only" flag in Management Studio they will mess up the Tivoli's backups (we are running… >>> More
Change Windows Authentication user for Sql Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
We're using Sql Server 2005 with Windows Authentication setup. So normally, when you log in using e.g. Sql Server Management Studio, it forces you to log in at MACHINE_NAME\Username. Anyways, on this one particular computer, the person said they had to make a new account called User01 to do something… >>> More
Option do not show schema names in SQL Server Management Studio

as seen on Server Fault - Search for 'Server Fault'
I love the fact that tree and list controls in Windows allows incremental searches. Just select a starting point, and type, and the control will select the best matching node for you. This works in SSMS, but there's an annoying problem, especially so in the table node. SSMS prefixes all table names… >>> More