Home > SQL Azure > SQL Azure Query Tool – Red Gate Query Anywhere

SQL Azure Query Tool – Red Gate Query Anywhere


Red Gate Query Anywhere is a web based tool to Query a SQL Azure database from anywhere. Its available for free in

http://www.queryanywhere.com/

Step 1: Please provide your Server name, Database, Username and Password and click Connect

clip_image001

Step 2: Once connected, you will be able to the Objects available in your database

clip_image003

Step 3: To Query the tables or view, you can directly start writing queries in Query pane and click “Execute”

clip_image005

Step 4: You can also create Stored Procedures

clip_image006

Step 5: To view the definition of Existing Stored Procedure or any other object, click on the Object name and expand and then click “ScriptAsCreate”

clip_image008

Conclusion: Red Gate Query Anywhere is nice and lightweight tool to query SQL Azure database, but still needs lot of improvement, such as

1. Showing the progress of executing queries

2. Object Name are displayed as Blank some times, which is eventually fixed after refreshing the UI

3. Option to login without providing database name and then pick a database and query

Friends, Play with this nice tool and post your feedback and comments !!!

In the next post we will review the other similar tools available

Project Houston – Microsoft SQL Azure Database Managerhttp://windows.azure.com

myLittleAdmin for SQL Azure (Currently in Beta, Pricing not announced) – http://mylittleadmin4sqlazure.cloudapp.net/

Hannsens SQL Azure Manager (Free) – http://hanssens.org/tools/sqlazuremanager/

Advertisements
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: