-
Notifications
You must be signed in to change notification settings - Fork 1
/
Start.ps1
41 lines (30 loc) · 1.05 KB
/
Start.ps1
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
$server = "localhost"
$database = "Nhea"
$user = "sa"
$password = "12Aa2sr13cx"
$containerName = "sqltest"
docker pull mcr.microsoft.com/mssql/server
docker run -e "ACCEPT_EULA=Y" -e "SA_PASSWORD=$password" -p 1433:1433 --name $containerName -d mcr.microsoft.com/mssql/server:latest
Start-Sleep -s 10
docker exec -it $containerName /opt/mssql-tools/bin/sqlcmd -S $server -U $user -P $password -Q "CREATE DATABASE $database;"
$logsScript = ""
Get-Content ".\SQL\nhea_Log.sql"| foreach {
$logsScript = $logsScript + $_
}
$mailQueueScript = ""
Get-Content ".\SQL\nhea_MailQueue.sql"| foreach {
$mailQueueScript = $mailQueueScript + $_
}
$localizationScript = ""
Get-Content ".\SQL\Localization.sql"| foreach {
$localizationScript = $localizationScript + $_
}
$Script = $logsScript + $mailQueueScript + $localizationScript
$batches = $Script -split "GO"
foreach($batch in $batches)
{
if ($batch.Trim() -ne ""){
Write-Output $batch
docker exec -it $containerName /opt/mssql-tools/bin/sqlcmd -S $server -U $user -P $password -Q "USE [$database];$batch"
}
}