Search

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

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)
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 (expand)

Product Language

English

Category

SQL Azure Database

Proposed Solution

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 when you write custom select statements via the "new query" window.

Primary Benefit

Improved Administration

Other Benefits

Improved/much faster administration / UI / performance and faster development are the benefits for dbas, developers, others.

Virtualization

 
File Attachments
File Name Submitted By Submitted On File Size  
edit-record-ui.JPG N-Play RE LLC 1/30/2013 31 KB
edit-record-ui.JPG N-Play RE LLC 1/30/2013 31 KB
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.
© 2013 Microsoft Corporation. All rights reserved. Microsoft Connect Terms of Use | Trademarks | Privacy Statement