MyLittleAdmin features

Procédure

What is MyLittleAdmin?

MyLittleAdmin is the utility offered in our Plesk packages to enable SQL Server database users to act on their database from their browser.

Although this utility can provide many services, it also has some limitations that we will review in this documentation.

Difference between the 'Lite' and 'Full' versions?

By default, MyLittleAdmin is offered as a Lite version (free of charge), but it is also available as a 'Full' version if you purchase a licence directly from the tool's publisher: http: //www.mylittleadmin.com/en/welcome.aspx.

Here is a table summarising the features available in the "Lite" and "Full" versions:

Full Version Lite Version (free)
Connection
SQL Server and Windows authentication
Network protocols and other options


x
x


x
x
Databases
System, Snapshot and User databases
List
Create, delete, rename
Properties, Permissions, Extended Properties

x
x
x
x

x
x

x (properties only)
Tables
System and User tables
List
Create, delete, rename, modify
View dependencies
Quick data edit
Export data to XLS, XML, CSV
Properties, Permissions, Extended Properties

x
x
x
x
x
x
x

x
x

x
x

x (properties only)
Columns
List
Create, delete, rename, modify
Properties, Permissions, Extended Properties

x
x
x

x

x (properties only)
Keys
Foreign and primary keys list
Create, delete, rename, modify

x
x

x
Constraints
List
Create, delete, rename
Properties, Extended Properties

x
x
x

x

x (properties only)
Triggers
List
Create, delete, rename, modify
View dependencies
Extended Properties

x
x
x
x

x

x
Indexes
List
Create, delete, rename
Properties, Extended Properties

x
x
x

x

x (properties only)
Statistics
List
Create, delete
Properties

x
x
x

x

x (properties only)
Views
System and User views
List
Create, delete, rename, modify
View dependencies
Export data to XLS, XML, CSV
Properties, Permissions, Extended Properties
Columns, Triggers, Indexes, Statistics


x
x
x
x
x
x
x


x
x

x

x (properties only)
x
Synonyms
List
Create, delete
Properties, Permissions, Extended Properties

x
x
x

x

x (properties only)
Stored Procedures
System and User stored procedures
List
Create, delete, rename, modify
View dependencies
Properties, Permissions, Extended Properties
Parameters list

x
x
x
x
x
x

x
x

x
x (properties only)
x
Functions
System and User table-valued functions
System and User scalar-valued functions
List
Create, delete, rename, modify
View dependencies
Properties, Permissions, Extended Properties
Parameters list

x
x
x
x
x
x
x

x
x
x

x
x (properties only)
x
Database Triggers
List
Create, delete, modify
Extended Properties

x
x
x

x

Assemblies
List
Delete

x
x

x
Types
System data types, User-defined data types, User-defined types, XML schema collections
List
Create, delete, rename, modify
View dependencies
Properties, Extended Properties

x
x
x
x
x

x
x

x
x (properties only)
Rules
List
Create, delete
View dependencies
Properties, Extended Properties

x
x
x
x

x

x
x (properties only)
Defaults
List
Create, delete
View dependencies
Properties, Extended Properties

x
x
x
x

x

x
x (properties only)
Service Broker
Message types, Contracts, Queues, Services, Routes, Remote Service Binding
List
Delete

x
x
x

x
x
Storage
Full Text Catalog, Partition Schemes, Partition Functions
List
Create, Modify, Delete

x
x
x

x
x
Users
List
Create, delete, rename
Properties, Extended Properties

x
x
x

x

Roles
Database roles, Application roles
List
Create, delete, modify
Properties, Extended Properties

x
x
x
x

x
x

Schemas
List
Create, delete, modify
Properties, Permissions, Extended Properties

x
x
x

x

Symetric and Asymetric Keys
List
Delete
Properties

x
x
x

x

Certificates
List
Delete
Properties

x
x
x

x

Logins
List
Create, delete, modify
Properties

x
x
x

x

Server roles
List
Properties

x
x

x
x
Credentials
List
Delete
Properties

x
x
x

x

x
Backup devices
List
Create, delete
Properties


x
x
x


x

x
Linked servers
List
Delete
Properties

x
x
x

x

Server Triggers
List
Create, delete, modify

x
x

x
Activity monitor
Process List

x
Tools and wizards
New query tool
Generate INSERT script wizard
CSV Import wizard
Backup wizard
Restore wizard
Detach wizard
Attach wizard
Shrink database wizard
Change password wizard

x
x
x
x
x
x
x
x
x

x







Preferences
Multi language
Multi skin

x
x

x
x
Misc.
Ability to enable/disable each feature
Ability to get the T-SQL script of each action
Silent logon module
and much more !

x
x
x
x

x

x
x

Going further

If you wish to install the full version of MyLittleAdmin after acquiring the licence, you can do so by following this procedure: https: //help.lws-hosting.com/en/How-to-install-myLittleAdmin-on-Plesk

Rate this article :

This article was useful to you ?

Article utileYes

Article non utileNo

Vous souhaitez nous laisser un commentaire concernant cet article ?

Si cela concerne une erreur dans la documentation ou un manque d'informations, n'hésitez pas à nous en faire part depuis le formulaire.

Pour toute question non liée à cette documentation ou problème technique sur l'un de vos services, contactez le support commercial ou le support technique

MerciMerci ! N'hésitez pas à poser des questions sur nos documentations si vous souhaitez plus d'informations et nous aider à les améliorer.


Vous avez noté 0 étoile(s)

Similar articles

1mn reading

How do I create a database in Plesk?

0mn reading

How do I create an ODBC link in Plesk?

0mn reading

How do I export a database to Plesk?

0mn reading

How do I install myLittleAdmin on Plesk?


Questions sur l'article
urbanoll Il y a 677 days
Suite à l'execution de requête, myLittleAdmin envoie l'erreur "Impossible d'afficher la page, car une erreur interne au serveur s'est produite."
See the
1 answers
Benjamin-LWS - Il y a 668 days

Bonjour, merci pour votre question,

L'erreur "Impossible d'afficher la page, car une erreur interne au serveur s'est produite." est générée lorsqu'une erreur interne se produit sur le serveur lors de l'exécution d'une requête. Il existe de nombreuses raisons pour lesquelles cela peut se produire, telles que des erreurs de configuration de serveur, des problèmes de mémoire, des erreurs dans les scripts PHP ou des problèmes de base de données.

Dans votre cas, il se peut que l'erreur soit dû une erreur de certificat de votre sous-domaine "mssql".

Ce sous-domaine est créé par défaut lors de l'achat de votre formule ASPNet, si vous l'avez supprimé, il vous suffira de le recréer sur Plesk et le certificat de ce sous-domaine sera automatiquement régénérer par la suite.

Nous vous invitons à contacter notre service support à travers votre espace client, afin de vous apporter une aide sur le problème que vous rencontrez. (https://aide.lws.fr/a/268)

Utile ?

Ask the LWS team and its community a question