Home Dashboard Directory Help
Search

Allow query and edit data via serverXYZ.database.windows.net online interface "on the fly" by N-Play RE LLC


Status: 

Closed


1
0
Sign in
to vote
Type: Suggestion
ID: 777895
Opened: 1/30/2013 7:08:48 AM
Access Restriction: Public
0
Workaround(s)
view

Description

Once you log in to your server serverXYZ.database.windows.net (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?
Details
Sign in to post a comment.
Posted by Microsoft 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.

Thanks,
Adam Mahood
Program Manager
SQL Server Database Systems
Sign in to post a workaround.
File Name Submitted By Submitted On File Size  
edit-record-ui.JPG 1/30/2013 31 KB
edit-record-ui.JPG 1/30/2013 31 KB