Définition
MyLittleAdmin est l'utilitaire proposé dans nos formules Plesk afin de permettre aux utilisateurs de base de données SQL Server de pouvoir agir sur cette dernière depuis leur navigateur.
Même si cet utilitaire peut rendre de nombreux services, il possède également des limitation que nous allons passer en revue dans cette documentation.
Procédure
MyLittleAdmin est l'utilitaire proposé dans nos formules Plesk afin de permettre aux utilisateurs de base de données SQL Server de pouvoir agir sur cette dernière depuis leur navigateur.
Même si cet utilitaire peut rendre de nombreux services, il possède également des limitation que nous allons passer en revue dans cette documentation.
Par défaut, MyLittleAdmin est proposé en version Lite (version gratuite) mais il est également disponible en version "Full" moyennant l'achat d'une licence directement auprès de l'éditeur de cet outil : http://www.mylittleadmin.com/en/welcome.aspx
Voici un tableau récapitulatif des fonctionnalités disponible en version "Lite" et en version "Full" :
| Full Version | Lite Version (free) | |
| Connection SQL Server and Windows authentification Network protocols and other options |
|
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 (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 |
| 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 |
Si vous souhaitez installer la version complète (FULL) de MyLittleAdmin après en avoir acquis la licence, vous pouvez effectuer l'opération en suivant cette procédure : https://aide.lws.fr/a/756
Pour aller plus loin
Si vous souhaitez installer la version complète (FULL) de MyLittleAdmin après en avoir acquis la licence, vous pouvez effectuer l'opération en suivant cette procédure : https://aide.lws.fr/a/756