SqlServerDsc

14.2.1-preview0002

DSCResources/DSC_SqlDatabase/DSC_SqlDatabase.schema.mof

                                [ClassVersion("1.0.0.0"), FriendlyName("SqlDatabase")]

class DSC_SqlDatabase : OMI_BaseResource

{

    [Key, Description("The name of the _SQL Server_ database.")] String Name;

    [Key, Description("The name of the _SQL Server_ instance to be configured.")] String InstanceName;

    [Write, Description("When set to `'Present'`, the database will be created. When set to `'Absent'`, the database will be dropped. Default value is `'Present'`."), ValueMap{"Present","Absent"}, Values{"Present","Absent"}] String Ensure;

    [Write, Description("The host name of the _SQL Server_ to be configured. Default value is `$env:COMPUTERNAME`.")] String ServerName;

    [Write, Description("The name of the collation to use for the new database. Default value is the collation used by the server.")] String Collation;

    [Write, Description("Specifies the version of the _SQL Database Compatibility Level_ to use for the specified database."), ValueMap{"Version80","Version90","Version100","Version110","Version120","Version130","Version140","Version150"}, Values{"Version80","Version90","Version100","Version110","Version120","Version130","Version140","Version150"}] String CompatibilityLevel;

    [Write, Description("The recovery model for the specified database."), ValueMap{"Simple","Full","BulkLogged"}, Values{"Simple","Full","BulkLogged"}] String RecoveryModel;

    [Write, Description("Specifies the name of the login that should be the owner of the database.")] String OwnerName;

};