Allow query and edit data via online interface "on the fly" - by N-Play RE LLC

Status : 


Sign in
to vote
ID 777895 Comments
Status Closed Workarounds
Type Suggestion Repros 0
Opened 1/30/2013 7:08:48 AM
Access Restriction Public


Once you log in to your server (SQL server azure db), select your db, then click on "Edit" next to the table where you want to edit data. Now click on "Data" link next to "Columns" and "Indexes and Keys".

First top 200 rows are displayed AND you can edit the actual records by clicking inside the field and making edits which is awesome!

But if your table is very large and very wide, let's say > 500k records, how would you get to certain records (not top 200 rows) but others and edit those on the fly as well? Clicking on "All Rows" freezes up the browser and when you run a query to pull up specific record you loose this "on the fly" edit capability. 

I'm not sure if this got overlooked but it'd be really, really, really nice to be able to edit any records through the UI (not having to write update statements) using this great online interface.

Are there any plans to adjust that?
Sign in to post a comment.
Posted by Adam [MSFT] on 3/22/2013 at 4:46 PM
Hey N-Play,

Thanks for your feedback regarding performance of the data editor in the SQL Azure Management Portal on tables with large row counts. The team is not currently pursuing a fix for this issue. However, we have a work-item tracking this should it come up for consideration in the future. We will keep large table performance in mind across other investments in the Azure Management Portals.

Adam Mahood
Program Manager
SQL Server Database Systems