Skip to content

README.md

Latest commit

 

History

History
29 lines (18 loc) · 778 Bytes

README.md

File metadata and controls

29 lines (18 loc) · 778 Bytes

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.