Resource Type: dsc_sqldatabase

Defined in:

lib/puppet/type/dsc_sqldatabase.rb

Providers:

powershell

Overview

The DSC SqlDatabase resource type. Automatically generated from ‘SqlServerDsc/DSCResources/MSFT_SqlDatabase/MSFT_SqlDatabase.schema.mof’

To learn more about PowerShell Desired State Configuration, please visit technet.microsoft.com/en-us/library/dn249912.aspx.

For more information about built-in DSC Resources, please visit technet.microsoft.com/en-us/library/dn249921.aspx.

For more information about xDsc Resources, please visit github.com/PowerShell/DscResources.

Properties

• ensure

  The basic property that the resource should be in.

  Supported values:

  • exists?
  • present
  • absent

Parameters

• dsc_collation

  Collation - The name of the SQL collation to use for the new database. Defaults to server collation.

• dsc_ensure

  Ensure - An enumerated value that describes if the database is added (Present) or dropped (Absent). Valid values are ‘Present’ or ‘Absent’. Default Value is ‘Present’. Valid values are Present, Absent.

• dsc_instancename

  InstanceName - The name of the SQL instance to be configured.

• dsc_name

  Name - The name of the SQL database.

• dsc_psdscrunascredential

  PsDscRunAsCredential

• dsc_servername

  ServerName - The host name of the SQL Server to be configured.

• name (namevar)
• provider

  The specific backend to use for this ‘dsc_sqldatabase` resource. You will seldom need to specify this — Puppet will usually discover the appropriate provider for your platform.