Big Data, Data Analytics and Data Science | BI-BIGDATA.com

This script explains creating a MS SQL Server database with default properties using PowerShell V3.0. In this script we are going to create a database called “PSDB”, by assuming that this database does not yet exist in current instance.

This is equivalent by creating database with following T-SQL Script.

CREATE DATABASE PSDB

Below is PowerShell V3.0 Script for same.

#Import SQL Server Module called SQLPS
Import-Module SQLPS -DisableNameChecking

#Your SQL Server Instance Name
$Inst = "YourInstanceName"
$Srvr = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Server -ArgumentList $Inst

#database PSDB with default settings
#by assuming that this database does not yet exist in current instance
$DBName = "PSDB"
$db = New-Object -TypeName Microsoft.SqlServer.Management.Smo.Database($Srvr, $DBName)
$db.Create()

#Confirm, list databases in your current instance
$Srvr.Databases |
Select Name, Status, Owner, CreateDate

Hope this helps.

Sandip