Fonctionnalités de MyLittleAdmin

Définition

Qu'est ce que MyLittleAdmin ?

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

Différence entre la version "Lite" et "Full" ?

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


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

 

 

Pour aller plus loin

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

Notez cet article


Vous avez noté 0 étoile(s)

Cet article vous a-t-il été utile ?

Merci !

N'hésitez pas à commenter nos pages afin de nous aider à les améliorer si besoin.

Vous n'avez pas trouvé votre réponse ?

Envoyez nous un message afin d'avoir une réponse rapidement



Top