This question has 2 parts. Is there a way to view the data that is stored locally. I understand that local table storage is actually done using SQLExpress behind the scenes. Where is that SQLExpress database located and can I open it using any query tool? Is there a specific account I need to use? Once the application is deployed to the Azure services, how do I query the data? The Google App Engine has a data viewer / query tool, does Azure have something similar?

The SQLExpress intance that you can see is only in the dev fabric and has no equivalent once you deply, so be careful about using it. You can try and use Linqpad to query your tables. Look at this post by Jamie Thomson.

azureazure-storage

Cody C

Reputation: 4797

Querying table storage data with Windows Azure

This question has 2 parts.

Is there a way to view the data that is stored locally. I understand that local table storage is actually done using SQLExpress behind the scenes. Where is that SQLExpress database located and can I open it using any query tool? Is there a specific account I need to use?
Once the application is deployed to the Azure services, how do I query the data? The Google App Engine has a data viewer / query tool, does Azure have something similar?

Upvotes: 8

Answers (8)

Chris Walford

Reputation: 46

You can view the tables and blobs in the development storage directly from Visual Studio 2010 Server Explorer

Upvotes: 0

Jason Haley

Reputation: 3800

You can also use the Windows Azure TabeleBrowser to view what is in the tables of a specific account name.

Upvotes: 0

Gaurav Mantri

Reputation: 136196

Since I am a new user and there is a limit of 1 link per answer for new users, hence this one more answer.

You may find these links useful as well when querying against Azure Table Storage:

http://msdn.microsoft.com/en-us/library/dd135725.aspx

Upvotes: 1

Gaurav Mantri

Reputation: 136196

For #1, may I recommend that you use our product Cloud Storage Studio. You can find more information about that from our website: /Products/CloudStorageStudio/Default.aspx.

It also has a "query" feature as well so that you can execute queries against your table storage.

Upvotes: 3

John Sheehan

Reputation: 78104

I found this on Codeplex and found it useful for browsing live storage: http://azurestorageexplorer.codeplex.com/

Upvotes: 5

Simon Munro

Reputation: 5419

The SQLExpress intance that you can see is only in the dev fabric and has no equivalent once you deply, so be careful about using it.
You can try and use Linqpad to query your tables. Look at this post by Jamie Thomson.

Upvotes: 2

Cody C

Reputation: 4797

I just found my answer to #1. Apparently the database is sitting under my default SQLExpress instance with a database that is the same name as my project. There are tables that map to my entities, each with columns that map to my properties.

Upvotes: 1

Rik

Reputation: 29243

I'm not sure about your first question, but for the second part: It's the same as when you're developing using the local table service, when you're using the ADO.NET Data Services client, at least. Just use the service root of your Azure storage account. Or you can use the REST interface, if you need the flexibility of the (schema-less) Azure Tables.

I'm not aware of a tool similar to GAE's data viewer, but it's not very difficult to build something like that yourself.

Upvotes: 1

Querying table storage data with Windows Azure

Answers (8)

Related Questions