shellpower.sqlserver 1.0.9-rc2

Provides powershell cmdlets for managing and configuring sql server in a repeatable manner, ideal for continuous integration/deployment scenarios.

This is a prerelease version of shellpower.sqlserver.
Install-Package shellpower.sqlserver -Version 1.0.9-rc2
dotnet add package shellpower.sqlserver --version 1.0.9-rc2
<PackageReference Include="shellpower.sqlserver" Version="1.0.9-rc2" />
For projects that support PackageReference, copy this XML node into the project file to reference the package.
paket add shellpower.sqlserver --version 1.0.9-rc2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

shellpower.sqlserver

Provides powershell cmdlets for managing and configuring sql server in a repeatable manner, ideal for continuous integration/deployment scenarios.

Usage

  • Install nuget package

    nuget install shellpower.sqlserver -outputdirectory packages
    
  • Create new file getting-started.ps1 with the following content

    
    # dot source the script
    . packages\bin\sqlserver.ps1 -dbServer "localhost" -dbName "foo"
    
    # Create sql user "bar" and assign it to db "foo"
    Add-DbUser -name "bar" -password "test-passw0rd!"
    
    # Remove sql user "bar" from db "foo" and from sql logins
    Remove-DbUser "bar"
    
  • Run .\getting-started.ps1

Refer to the tests in the source code for more examples.

shellpower.sqlserver

Provides powershell cmdlets for managing and configuring sql server in a repeatable manner, ideal for continuous integration/deployment scenarios.

Usage

  • Install nuget package

    nuget install shellpower.sqlserver -outputdirectory packages
    
  • Create new file getting-started.ps1 with the following content

    
    # dot source the script
    . packages\bin\sqlserver.ps1 -dbServer "localhost" -dbName "foo"
    
    # Create sql user "bar" and assign it to db "foo"
    Add-DbUser -name "bar" -password "test-passw0rd!"
    
    # Remove sql user "bar" from db "foo" and from sql logins
    Remove-DbUser "bar"
    
  • Run .\getting-started.ps1

Refer to the tests in the source code for more examples.

Release Notes

This package includes the powershell cmdlets, which can be referenced by your powershell scripts for performing common sql server configuration operations.

Dependencies

This package has no dependencies.

This package is not used by any popular GitHub repositories.

Version History

Version Downloads Last updated
1.0.9-rc2 49 7/3/2019
1.0.9-rc1 419 1/21/2019
1.0.8-alpha 98 12/27/2018
1.0.7-alpha 134 12/19/2018
1.0.6-alpha 109 12/17/2018
1.0.5-alpha 101 12/11/2018
1.0.4-alpha 99 12/8/2018
1.0.1-alpha 102 11/19/2018
1.0.0-alpha 105 11/19/2018