The xDatabase module contains the xDatabase, xDatabaseLogin, xDatabaseServer, and xDBPackage resources.
This project has adopted this Code of Conduct.
For each merge to the branch master
a preview release will be
deployed to PowerShell Gallery.
Periodically a release version tag will be pushed which will deploy a
full release to PowerShell Gallery.
Please check out common DSC Community contributing guidelines.
A full list of changes in each version can be found in the change log.
Please se the section Resources.
You can review the Examples directory in the repository for some general use scenarios for all of the resources that are in the module.
For information on Data-Tier Applications please refer to Understanding Data-tier Applications.
- xDatabase handles creation/deletion of a database using a dacpac or SQL connection string.
- xDatabaseLogin not yet written..
- xDatabaseServer not yet written..
- xDBPackage allows extraction of a dacpac or import of a bacpac from a database.
- Credentials: The credential to connect to the SQL server.
- SqlServer: The SQL server.
- SqlServerVersion: The version of the SQL Server. This property can take the following values: { 2008-R2 | 2012 | 2014 | 2016 | 2017 | 2019 }
- BacPacPath: The path to the .bacpac file to be used for database restore If this is used, the DacPacPath (see below) cannot be specified.
- DacPacPath: The path to the .dacpac file to be used for database schema deploy. If this is used, the BacPacPath (see above) cannot be specified.
- DacPacApplicationName: For deploying a database using .dacpac file, an application name with which the dacpac is registered. This is needed to support database upgrade using .dacpac files. This must specified if DacPacPath is provided.
- DacPacApplicationVersion: This is an optional parameter needed for registration for database deployment using .dacpac files for dacpac registration.
- DatabaseName: The name of the database to be deployed.
Not yet written.
Not yet written.
- DatabaseName: The name of the database to be deployed.
- SqlServer: The SQL server.
- SqlServerVersion: The version of the SQL Server. This property can take the following values: { 2008-R2 | 2012 | 2014 | 2016 | 2017 | 2019 }
- Path: The path to the .bacpac or .dacpac file to be used to export a database to a bacpac or extract a db to a dacpac respectively.
- Type: This property can take the following values for dacpac extraction and bacpac export: { DACPAC | BACPAC }