scripts/win/docker/restore.ps1
|
Clear-Host # ╭────────────────────────────────────────────────────────╮ # │ 🛠️ SQL Server Docker Database Provision & Restore 🔄 │ # ╰────────────────────────────────────────────────────────╯ Write-Host "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━" -ForegroundColor DarkCyan Write-Host "🛠️ SQL Server Docker Database Provision & Restore" -ForegroundColor Cyan Write-Host "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━" -ForegroundColor DarkCyan Write-Host "" . "$env:BORG_ROOT\config\globalfn.ps1" # 🔐 Switching to sql work folder while preserving the current location to switch back $currentLocation = (Get-Location).Path if (Test-Path $sqlBackupFolder) { Set-Location $sqlBackupFolder } # 🚀 Step 1: Create container Write-Host "" Write-Host "🚀 Step 1: Creating SQL Server $ContainerName container..." -ForegroundColor Cyan & "$dockerFolder\clean.ps1" & "$dockerFolder\sql-container.ps1" # 📤 Step 2: Upload backup Write-Host "📤 Step 2: Uploading backup file to container..." -ForegroundColor Cyan $result = & "$dockerFolder\upload.ps1" if (-not $result) { Write-Host "❌ Upload or selection failed." -ForegroundColor Red exit 1 } # 🕒 Step 3: Wait for SQL to be ready Write-Host "" Write-Host "🕒 Step 3: Waiting for SQL Server to initialize..." -ForegroundColor Cyan $ready = $false $timeout = 600 $startTime = Get-Date $attempt = 1 while (-not $ready) { try { $logOutput = docker logs $ContainerName if ($logOutput -match "SQL Server is now ready for client connections") { Write-Host "✅ SQL Server in '$ContainerName' is ready." -ForegroundColor Green $ready = $true } else { Write-Host "⏳ Attempt $attempt - SQL not ready yet..." -ForegroundColor DarkYellow Start-Sleep -Seconds 1 $attempt++ } } catch { Write-Host "💥 Error while checking logs: $_" -ForegroundColor Red Start-Sleep -Seconds 5 } $elapsed = (Get-Date) - $startTime if ($elapsed.TotalSeconds -ge $timeout) { Write-Host "❌ SQL Server failed to initialize within 10 minutes." -ForegroundColor Red exit 1 } } Start-Sleep -Seconds 2 switch ($result.Type) { "bacpac" { Write-Host "🧨 Step 4: Restoring database from bacpac: '$result.Path'..." -ForegroundColor Cyan & "$dockerFolder\sql-restore-bacpac.ps1" -BacpacPath $result.Path } "bak" { $fileNameOnly = [System.IO.Path]::GetFileName($result.Path) Write-Host "🧨 Step 4: Restoring database from bak: '$fileNameOnly'..." -ForegroundColor Cyan & "$dockerFolder\sql-restore.ps1" $containerName $fileNameOnly } default { Write-Host "❌ Unknown restore type: $($result.Type)" -ForegroundColor Red exit 1 } } # 🔚 Restore working location Set-Location $currentLocation # 🏁 Completion banner Write-Host "`n✅ All steps completed successfully!" -ForegroundColor Green Write-Host "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━" -ForegroundColor DarkCyan Write-Host "🏁 SQL Container & Restore Operation Finished" -ForegroundColor Cyan Write-Host "━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━━" -ForegroundColor DarkCyan |