Untitled
unknown
plain_text
a month ago
2.1 kB
4
Indexable
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: $_" }
Editor is loading...
Leave a Comment