Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

try { < # Create Database # > Write - Host - ForegroundColor Cyan [ SQL ] : Starting SQL Tasks # Import SqlServer

try {
<# Create Database #>
Write-Host -ForegroundColor Cyan "[SQL]: Starting SQL Tasks"
# Import SqlServer Module
if(Get-Module -Name sqlps){Remove-Module sqlps}
Import-Module -Name SqlServer
# D1: Check for the existence of the database
$serverName ="SRV19-PRIMARY\SQLEXPRESS"
$databaseName = "MyDatabase-NetObjects"
# Create connection to server
$connectionString = "Data Source=$($serverName); Initial Catalog=master;Integrated Security=True;"
$sqlConnection = New-Object System.Data.SqlClient.SqlConnection
$sqlConnection.ConnectionString = $connectionString
$sqlConnection.Open()
# Create query to detect if database exists
$detectQuery = "Select name FROM sys.databases WHERE name ='$($databaseName)'"

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Relational Database Design With Microcomputer Applications

Authors: Glenn A. Jackson

1st Edition

0137718411, 978-0137718412

More Books

Students also viewed these Databases questions