Querying table storage data with Windows Azure

Question

This question has 2 parts.

1. 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?

2. 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?

Answer 1

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

Answer 2

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.