Hébergement Mutualisé Windows Plesk 30 Mars 2021 Créé par Aurélien 1mn de lecture

MyLittleAdmin features

Lien de l'article

Sommaire

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 ?

Yes