Public/New-Database.ps1
|
function New-Database { <# .SYNOPSIS Creates a new database and returns the connection parameters. .DESCRIPTION Uses a existing test instance and creates a database for (temporary) use. It keeps an open connection to the instance for later removal. .EXAMPLE PS> $Instance = New-SqlTestInstance PS> $InstanceConnection = $Instance | Connect-TSqlInstance PS> New-SqlTestDatabase -Instance $Instance -InstanceConnection $InstanceConnection ConnectionString : Data Source=(LocalDb)\MSSQLLocalDB;Connect Timeout=30;Integrated Security=True;Initial Catalog=a48b028c DataSource : (LocalDb)\MSSQLLocalDB ConnectTimeout : 30 Version : v11.0 InitialCatalog : a48b028c InstanceConnection : Microsoft.Data.SqlClient.SqlConnection #> [CmdletBinding()] param ( # Specifies the instance, to create the database in. [Parameter( Mandatory )] [ValidateNotNullOrEmpty()] [PsObject] $Instance, # Specifies a open sql connection to the instance. [Parameter( Mandatory )] [ValidateNotNullOrEmpty()] [Microsoft.Data.SqlClient.SqlConnection] $InstanceConnection, # Specifies the name of the database to create. [Parameter()] [ValidateNotNullOrEmpty()] [string] $Name = ( [string](New-Guid) ).Substring(0, 8) ) $Database = $Instance.PsObject.Copy() $Database | Add-Member InstanceName $Database.Name $Database.Name = $Name Invoke-TSqlCommand "CREATE DATABASE [$Name]" -Connection $InstanceConnection $Database | Add-Member InitialCatalog $Name $Database.ConnectionString += ";Initial Catalog=$( $Database.InitialCatalog )" $Database | Add-Member InstanceConnection $InstanceConnection Write-Output $Database } |