14

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"

Improve this question
1
  • 1
    use ssms to connect to azure and view the data,if that's what you meant by viewing Commented Oct 4, 2016 at 7:01

3 Answers 3

Reset to default
23

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.

...

Improve this answer
Sign up to request clarification or add additional context in comments.

Comments

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/

Improve this answer

2 Comments

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 azure.microsoft.com/en-us/documentation/articles/…
Why would you duplicate a part of your answer in the comments section?
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.

Improve this answer

2 Comments

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.
@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."

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.