Changelog | SQLMigration | powershelldba.de

2026-06-21

Script variant documentation (commit 556dfc6)
Handbook: TwoPhase migrates ALL object types via script (not just Direct)
Secrets TODO notes and troubleshooting corrected; documentation version 1.2
README: Credentials/Proxies + Database users added, SSIS (not supported) removed
Migration procedures (Direct/Detour) and automatic post-processing documented; version 1.2

Direct path with admin-share UNC (commit e5a74fc)
Direct (one-run) path now correctly addresses target via admin-share UNC
New Invoke-DirectDatabaseTransfer: backup/detach locally on source, robocopy files to target's admin share (\\target\D$\...), restore/attach using target's LOCAL paths
New ConvertTo-AdminShareUnc function for cross-machine path conversion
Handbook notes updated

Auto-detect connection mode and set target backup path (commit effcdd9 + 4814a5d)
Connection panel now includes counterpart server field and "Verbindung prüfen" (Test-ServerReachable) button
Procedure selector: Auto/Direct/Detour (Auto picks Direct when counterpart is reachable, otherwise two-phase detour)
Auto-set Exchange path to target backup directory via admin-share UNC when counterpart is found
New Invoke-DirectMigration: single-pass migration when both servers visible from source
Databases via robust backup/robocopy/restore (Mode Full)
Logins/Jobs/Linked Servers/Credentials/Proxies via Copy-Dba* functions
Automatic Mixed Mode enablement, policy handling, and post-restore cleanup
Handbook updated with procedure details and counterpart field documentation

Script-based migration for Agent Jobs, Linked Servers, Credentials, Proxies (commit c67fb11)
Cross-domain compatible: export to script on source, import on target (no simultaneous connection required)
New Export-MigrationAgentJobs / Export-MigrationProxies (via Export-DbaScript)
New Export-MigrationLinkedServers / Export-MigrationCredentials (decrypt secrets on source)
New generic Import-MigrationScriptFile (batch split on GO, resilient per batch)
Undecryptable secrets recorded in migration_secrets_TODO.txt for manual follow-up
State file tracks ObjectScripts paths; Phase 1 exports, Phase 2 imports in dependency order
Old "Direct only" warning removed

Login migration via Export-DbaLogin; PBM policy management (commit 3064493)
Two-phase capable: avoids requirement for simultaneous visibility of both servers
Phase 1 (source): Export-MigrationLogins writes CREATE LOGIN script (SID + hashed password) to migration_logins.sql
Phase 2 (target): Import-MigrationLogins runs script batch-by-batch via Invoke-DbaQuery
New Set-NamedPbmPolicyState (replaces Disable-NamedPbmPolicy); handles New_Password_Policy
Phase 2 order: Mixed Mode → disable policy → import logins → re-enable policy → remove dead AD logins
Logins removed from "Direct-only" warning; handbook updated

Target auto-prep: Mixed Mode, PBM policy, SQL login detection (commit 39a06d4)
New Test-SourceHasSqlLogins: detects non-system SQL logins; result stored in state file
New Enable-MixedModeIfNeeded: switches target from Windows-only to Mixed auth via SMO, restarts SQL engine
New Disable-NamedPbmPolicy: disables New_Password_Policy before login import if present
Both functions are WhatIf-aware
Wired into Phase 2 (target) under Logins object; handbook updated

Backup/Restore and Detach/Attach with robocopy (commit 3cec03f)
Default strategy changed to local-first (avoids SQL service account UNC permission issues)
Phase 1: backup to server's default directory, robocopy to Exchange path
Phase 2: robocopy from Exchange path to target's local backup directory, restore from local
Detach/Attach also uses robocopy; Phase 2 copies to target's DATA/LOG directories, attaches from there
New Invoke-PostRestoreCleanup (Phase 2): repairs orphaned DB users, sets owner to sa (by SID 0x01)
New Remove-DeadAdLogin (Phase 2): removes Windows logins whose domain account was deleted (SID-only, safety checks)
No more direct-UNC attempt / permission fallback dialog
Handbook updated with strategy, automatic post-restore steps, and troubleshooting

Fix GUI hang on startup (commit 63d645a)
TabControl.ItemSize setter raised SizeChanged event, causing infinite recursion in FitTabWidth handler
Fixed with re-entrancy guard; form now completes quickly
Suppress "unapproved verbs" warning on startup by importing migration modules with -DisableNameChecking

Fix GUI ListView headers hidden by button panel (commit 491e3e9)
TabPage dock order: ListView (Fill) must be child index 0 to prevent overlap
Set explicitly to show column headers
TabControl strip now full-width and dark themed (owner-draw tab items stretched to full width)

Fix broken migration calls (inline comments on backtick-continuation) (commit ae1017e)
Inline comments on backtick-continuation lines caused parameter parsing failures
All Invoke-DatabaseMigrationBackupRestore/DetachAttach calls fixed
Every migration previously failed at runtime

Auto-cleanup of backup files and fallback callback (commit aeb3c05)
Invoke-Migration.psm1: FallbackCallback parameter in Invoke-DatabaseMigrationBackupRestore
Local backup file automatically deleted after successful Copy/Restore
Fallback-Log level upgraded from INFO to WARN
SQL-Migration.ps1: FallbackCallback wired into Phase 1 and Phase 2
Fallback triggers MessageBox warning + status bar turns yellow
Old manual cleanup instructions removed

2026-05-18

SQLMigration changelog