Create SQL Database using PowerShell

Using this PowerShell code, you can either run it directly in the console, or make a CreateDB.ps1 file, to add a new SQL DB. Note, you could use with some of the previous PS code to create a single solution to automate the creation of the database, add the schema, and add tables.

[String]$dbname = "MyNewDatabase";

# Open ADO.NET Connection with Windows authentification to local SQLSERVER.
$con = New-Object Data.SqlClient.SqlConnection;
$con.ConnectionString = "Data Source=.;Initial Catalog=master;Integrated Security=True;";
$con.Open();

# Select-Statement for AD group logins
$sql = "SELECT name
        FROM sys.databases
        WHERE name = '$dbname';";

# New command and reader.
$cmd = New-Object Data.SqlClient.SqlCommand $sql, $con;
$rd = $cmd.ExecuteReader();
if ($rd.Read())
{	
	Write-Host "Database $dbname already exists";
	Return;
}

$rd.Close();
$rd.Dispose();

# Create the database.
$sql = "CREATE DATABASE [$dbname];"
$cmd = New-Object Data.SqlClient.SqlCommand $sql, $con;
$cmd.ExecuteNonQuery();		
Write-Host "Database $dbname is created!";


# Close & Clear all objects.
$cmd.Dispose();
$con.Close();
$con.Dispose();