Knowledge Base
Using myLittleAdmin
What is myLittleAdmin
myLittleAdmin for SQL Server is a Web-based database management system, which enables you to administer your MS SQL databases online.With myLittleAdmin, you can perform most database administration functions, including:
- Manage the tables, fields and indexes structure as well as the record content
- Create views and stored procedures
- Import and export data
- Query your databases
- Back up and restore your databases
Comparing myLittleAdmin to Enterprise Manager
For MS SQL database administration, myLittleAdmin is very similar to Enterprise Manager in both features and look-and-feel. The following table provides a feature comparison between the two tools.* Available through Support indicates that the feature is not available directly in the myLittleAdmin tool we offer. Please contact us if you need to use these features.
| Features | Enterprise Manager | myLittleAdmin |
| Connection | ||
| DSN-less and DSN connection | DSN-less only | |
| Windows and SQL server authentication | Yes | Yes |
| Trusted connection | Yes | Yes |
| User levels | Yes | Yes |
| Databases | ||
| List | Yes | Yes |
| Create, delete, rename and generate SQL script | Yes | Yes |
| Display space used | Yes | Yes |
| Backup | Yes | Yes |
| Detach | Yes | Yes |
| Shrink | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Transaction Rollback | Yes | Available through Support |
| Tables | ||
| List | Yes | Yes |
| Data search | Yes | Yes |
| Quick data edit | Yes | Yes |
| Create, delete, rename and generate SQL script | Yes | Yes |
| Export data to character-delimited, XLS or XML files | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Columns | ||
| List | Yes | Yes |
| Create, delete, rename and edit | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Indexes | ||
| List | Yes | Yes |
| Create, delete, rename and generate SQL script | Yes | Yes |
| Rebuild | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Relationships (Foreign Keys) | ||
| List | Yes | Yes |
| Create, delete, rename and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Triggers | ||
| List | Yes | Yes |
| View T-SQL | Yes | Yes |
| Create, delete, rename, edit and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Constraints (Checks) | ||
| List | Yes | Yes |
| Create, delete, rename, edit and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Views | ||
| List | Yes | Yes |
| View T-SQL | Yes | Yes |
| Data search | Yes | Yes |
| Create, delete, rename, edit and generate SQL script | Yes | Yes |
| Export data to character-delimited, XLS or XML files | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Stored procedures | ||
| List | Yes | Yes |
| View T-SQL | Yes | Yes |
| Create, delete, rename, edit and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Users | ||
| List | Yes | Yes |
| Create, delete, edit and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Roles | ||
| List | Yes | Available through Support |
| Create, delete and generate SQL script | Yes | Available through Support |
| Rules | ||
| List | Yes | Available through Support |
| Create, delete, rename and generate SQL script | Yes | |
| Link to UDT and columns | Yes | Available through Support |
| Add, delete and modify extended properties | Yes | Available through Support |
| Defaults | ||
| List | Yes | Yes |
| Create, delete, rename and generate SQL script | Yes | Yes |
| Link to UDT and columns | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| User-defined types (UDT) | ||
| List | Yes | Yes |
| Create, delete, rename, edit and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| User-defined functions (UDF) | ||
| List | Yes | Yes |
| View T-SQL | Yes | Yes |
| Create, delete, rename, edit and generate SQL script | Yes | Yes |
| Add, delete and modify extended properties | Yes | Yes |
| Management - Backup Devices | ||
| List | Yes | Available through Support |
| Create, delete, rename and edit | Yes | Available through Support |
| Management - Activity | ||
| Process information | Yes | Available through Support |
| Locks / process id | Yes | Available through Support |
| Locks / objects | Yes | Available through Support |
| Kill process | Yes | Available through Support |
| Error Log | ||
| Display current and archived error logs | Yes | Available through Support |
| Logins | ||
| List | Yes | Yes |
| Create, delete, edit | Yes | Yes |
| Tools | ||
| Query analyzer | Yes | Yes |
| Generate INSERT scripts | Yes | |
| CSV Import wizard | Yes | |
| BackUp wizard | Yes | |
| Restore wizard | Yes | |
| Attach database | Yes | Available through Support |
| Shrink wizard | Yes | |
| Change Password | Yes | Available through Support |
| Options | ||
| Multi languages | Yes | Yes |
| Multi skins | Yes | |
| Show/hide system objects | Yes | Yes |
* Available through Support indicates that the feature is not available directly in the myLittleAdmin tool we offer. Please contact us if you need to use these features.
Perform basic operations in myLittleAdmin
To use myLittleAdmin, follow these steps:
- Log into your control panel.
- Go to Scripting and Add-Ons > MS SQL to get to the Manage MS SQL tool
- In the Current MS SQL Databases section, click login for the database you want to administer to go to myLittleAdmin.
- Use the tree on the left to navigate to the features you want to use.
Quick Help
Click myLittleAdmin at the top of the tree to display the main page, which has a legend for the icons used throughout the tool.
Connection
- To log into the MS SQL server, click Connection, and then DNS-less.
- Click Connect. The left menu displays the database server name, under which are folders for Databases, Security, and Tools.
Database Functions
Click a database name to view detailed statistics on the database, including file MDF and log file sizes, backup dates, and total disk size.
Click the options in the tree on the left to perform various functions:
- Tables: You can view a list of the tables in the database and access related functions.
To create a new table, click the yellow star on the top right.
Use the icons to the right of each table to:- View table content, add to it and export it in different file formats
Important: You must create an index on a table with a primary key before you can edit the data in the table. - Search for data within the table
- Rename the table
- Manage the table structure, including relationships, triggers, constraints, and indexes
- Create the SQL code to create the table
- Delete the table
- View table content, add to it and export it in different file formats
- Views: You can create and edit views.
- Stored Procedures: Stored procedures are a powerful feature of SQL Server. You can easily create, edit, view, export as SQL, and delete stored procedures.
Security
Click Server roles to view descriptions of server roles.
Tools
Click the options in the tree on the left to perform various functions:
- Query Analyzer: Query Analyzer is one of the most powerful features of SQL Server, in which you can run all sorts of queries.
- Generate INSERT Scripts: This feature allows you to create SQL code that takes the data in a selected table and creates an INSERT script that you can then use to rebuild the table and data, should you need it later.
- CSV import wizard: This wizard walks you through importing data from an external CSV file into a table in your database. This feature is useful for initially populating your database.
- BackUp wizard
- Restore wizard
.CSV Import Wizard is Not Completing the Task
When attempting to upload a .CSV file that is more than 1MB in size using myLittleAdmin, the service may on occasion take longer than expected, then display an error message similar to the following:
'Active Server Pages error 'ASP 0113'
Script timed out
/scripts/tools/csv_import_5.asp
The maximum amount of time for a script to execute was exceeded. You can change this limit by specifying a new value for the property Server.ScriptTimeout or by changing the value in the IIS administration tools.'
If you encounter this error message, please attempt to reupload the .CSV file after saving it into several smaller pieces (it is recommended that you try using files that are around 400KB or smaller in size).
No support for Enterprise Manager
'While we recognize that the Enterprise Manager has become a popular tool to manage MS SQL databases remotely, we do not support it due to the potential security risks it poses in a Web hosting environment.
- Enterprise Manager requires port 1433 to be open for managing databases remotely. Opening this port to the Internet creates a network vulnerability to worms and Denial of Service (DoS) attacks.
- Using Enterprise Manager, customers can see the names of all databases on the database server, including yours. Knowing the database name is the first step in accessing your data.
We offer myLittleAdmin through our Manage MS SQL tool.
With myLittleAdmin, you can do almost everything you did with Enterprise Manager. It also has a similar look-and-feel as Enterprise Manager, so most people transition easily.