Untitled

try {
    # Check for SQL Server instance
    $instance = "localhost\SQLEXPRESS"
    $dbExists = Invoke-Sqlcmd -Query "SELECT name FROM sys.databases WHERE name = 'ClientDB'" -ServerInstance $instance -Database master -ErrorAction Stop

    if ($dbExists) {
        Write-Host "'ClientDB' exists. Deleting..."
        Invoke-Sqlcmd -Query "DROP DATABASE ClientDB" -ServerInstance $instance
        Write-Host "'ClientDB' deleted."
    } else {
        Write-Host "'ClientDB' does not exist."
    }
} catch {
    Write-Host "Error checking/deleting ClientDB: $_"
}

try {
    Write-Host "`nCreating 'ClientDB'..."
    Invoke-Sqlcmd -Query "CREATE DATABASE ClientDB" -ServerInstance $instance
    Write-Host "'ClientDB' created."
} catch {
    Write-Host "Error creating ClientDB: $_"
}

try {
    Write-Host "`nCreating table 'Client_A_Contacts'..."
    $tableQuery = @"
CREATE TABLE Client_A_Contacts (
    FirstName NVARCHAR(50),
    LastName NVARCHAR(50),
    Email NVARCHAR(100),
    Phone NVARCHAR(20),
    Company NVARCHAR(100)
)
"@
    Invoke-Sqlcmd -Query $tableQuery -ServerInstance $instance -Database ClientDB
    Write-Host "'Client_A_Contacts' table created."
} catch {
    Write-Host "Error creating table: $_"
}

try {
    Write-Host "`nImporting data from CSV..."
    $data = Import-Csv "$PSScriptRoot\NewClientData.csv"
    foreach ($row in $data) {
        $insertQuery = "INSERT INTO Client_A_Contacts (FirstName, LastName, Email, Phone, Company) VALUES (N'$($row.FirstName)', N'$($row.LastName)', N'$($row.Email)', N'$($row.Phone)', N'$($row.Company)')"
        Invoke-Sqlcmd -Query $insertQuery -ServerInstance $instance -Database ClientDB
    }
    Write-Host "Data imported successfully."
} catch {
    Write-Host "Error importing data: $_"
}

try {
    Write-Host "`nExporting table contents to SqlResults.txt..."
    Invoke-Sqlcmd -Database ClientDB –ServerInstance $instance -Query "SELECT * FROM dbo.Client_A_Contacts" > "$PSScriptRoot\SqlResults.txt"
    Write-Host "SqlResults.txt created."
} catch {
    Write-Host "Error exporting SQL results: $_"
}