13

I have a web app in azure which let user to input some data. I want to save them in sql db which I created in azure. Is there a way to check/view the entered data . I am referring to something like "mysql workbench for mysql"

IndexOutOfDevelopersException
  • 1,364
  • 7
  • 15
  • 28
Madhavi
  • 157
  • 1
  • 1
  • 8

3 Answers3

22

You may also view the data in your browser using Azure Portal

Select your DB and then "Query editor" in the menu and start querying.

...

Ferdinand Fejskid
  • 527
  • 4
  • 15
8

You can download sql server management studio to access your data. Also you can you Visual Studio Community Edition or Visual Code.

Below is the link for download

http://go.microsoft.com/fwlink/?LinkID=828615

you also need to configure the sql database firewall to get access to your database. A Step by Step tutorial to configure that can be found in the following URL

https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/

TheGameiswar
  • 27,855
  • 8
  • 56
  • 94
Julian Castiblanco
  • 421
  • 5
  • 10
  • 2
    you also need to configure the sql database firewall to get access to your database. A Step by Step tutorial to configure that can be found in the following URL https://azure.microsoft.com/en-us/documentation/articles/sql-database-configure-firewall-settings/ – Julian Castiblanco Oct 04 '16 at 15:59
  • Why would you duplicate a part of your answer in the comments section? – hellouworld Feb 13 '20 at 07:54
5

Alternatively, you can query your database via SSMS: https://azure.microsoft.com/en-us/documentation/articles/sql-database-manage-azure-ssms/

Free to use: MSDN SSMS download page

Once connected to your database, simply right clicking on a table in the Object Explorer and selecting 'View top 1000 rows' would give you a view of - you guessed it- the top 1000 rows. You may query against the database there with any SQL query; For instance- removing the TOP 1000 from the generated query will return all of the data in that table.

Dan Rediske
  • 852
  • 4
  • 14
  • 1
    As of SQL 2016, SSMS is a separate download from SQL Server. If I'm not mistaken the license is now effectively free for developers. – Shannon Lowder Oct 05 '16 at 18:54
  • @ShannonLowder : That's true! From the download page I linked: "This generally available release of SSMS is free and does not require a SQL Server license to install and use." – Dan Rediske Oct 05 '16 at 19:00