Home > SQL Azure > SQL Azure Query Tool–myLittleAdmin

SQL Azure Query Tool–myLittleAdmin


myLittleAdmin for SQL Azure is web-based interface to manage SQL Azure server and databases

myLittleAdmin is available for free under Public Beta, but it will be charged once it goes live. Pricing information is not disclosed yet.

You can Install myLittleAdmin for SQL Azure in your own IIS server or you can access it directly from http://mylittleadmin4sqlazure.cloudapp.net/ 

For list of features and support information, please visit http://azure.mylittleadmin.com/azure/en/default.aspx

Login – To connect to SQL Azure server, provide Servername, Database, Login and Password to login to your server

image

You can also connect without specifying the database name

To Encrypt the connection or change the Connection Time out click on “Options” and select the required option

image

Click “Connect” to connect to your SQL Azure server

Dashboard – Databases Tab (Default) displays the available System and User databases

image

Dashboard – Connection Tab displays the License and Connection information

image

image

Server Info displays the detailed information about the connected SQL Azure server

image

To disconnect from the server, use the “Disconnect” option in “Connection” tab.

image

Database Tab To Manage Database Object

Click on User Databases and select your database to view Tables, Views, Synonyms, Stored Procedures, Functions, Users, Roles and Schema

image

By selecting a Table, you can access the following functions in the Right side pane

image

image – Open the table to view or modify data
image

You have option to Export to CSV, XML and Excel 2003 format. You can also filter data, modify or insert or delete records

image – Table Designer

image

image – View Dependencies

image

image-View Properties

image

image-View Permissions

image

Creating Views

To create View, Click on “Views” node and click on “New”  image Icon on Right side pane, and then modify the template to specify View name, Schema Name and SQL query to create view and click “Create”

image

Creating Synonyms

To create Synonyms, Click on “Synonyms” node and click on “New” image Icon on Right side pane, then enter the Synonym name, select the Schema and then Object Type and name and click “Create”

 image

Similarly you can create or modify or drop Stored Procedures, Functions, Database Triggers and View Assemblies and Types available

image

Manage Database Users, Roles and Schemas

image

Security Tab: Manage Logins, View Server Roles

image

To create new login, click on New Icon in Right side pane after selecting Logins node

image

image

Available Tools

image

You can use “New Query” tool to run adhoc queries, Type your query and click on “Submit”

image

Query options available

image

You can view the results of Query in Results tab

image

You can view Informational and Error messages in Messages tab

image

Generate Insert script for Tables

image

Select database, and table and specify the columns and then click on “Generate” to create insert SQL script

Generated Insert Script

image

To save the script, click on “Save As” and proceed

Import CSV Files

image

Options for import

image

I tried couple of different format and options, even after Import option is not working even after directly trying to import files exported from Data View itself

Always getting the following error

image

I wasn’t sure why its not able to see the table from Import option even for an administrator account

Preferences Tab

image

Under Preferences, you can select you preferred Language, available languages are English, French, Deutsch and Japanese.

Currently there is only one Skin and Export option available.

You can access the myLittleAdmin forums from Help tab.

Conclusion: myLittleAdmin for SQL Azure is a full fledge light weight Management Studio, which  supports all database objects, comes with useful handy tools and also available in 4 different languages.

When compared to Project Houston and Red Gate Query Anywhere, myLittleAdmin supports more features and also fast performing.

For detailed comparison of features across Project Houston, Red Gate Anywhere and myLittleAdmin for SQL Azure, please read this document

http://azure.mylittleadmin.com/azure/Comparing_SQL_Azure_Management_Tools.pdf 

I hope you all find this information useful !!!

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: