elseif ($Action -eq "Remove") net stop "MSSQL $$InstanceName" 2>$null sc.exe delete "MSSQL $$InstanceName" Remove-Item -Path $RegPath -Recurse -Force -ErrorAction SilentlyContinue Write-Host "Service removed from this machine."
Introduction: The Portable Paradox In the world of enterprise software, "portability" is often a dirty word. Applications are expected to hook into registries, spawn Windows services, and embed themselves deeply into the operating system. Microsoft SQL Server Express—the free, entry-level version of the world’s most popular enterprise RDBMS—is the epitome of this "installed" philosophy. ms sql server express portable
sc create "MSSQL$%INSTANCE%" binPath= "%SQLROOT%\MSSQL\Binn\sqlservr.exe -s%INSTANCE%" start= auto reg add "HKLM\SOFTWARE\Microsoft\Microsoft SQL Server%INSTANCE%\MSSQLServer\Parameters" /v SQLArg0 /d "-s%INSTANCE%" /f net start MSSQL$%INSTANCE% spawn Windows services
@echo off set DRIVE=%~d0 set SQLROOT=%DRIVE%\SQLPortable set INSTANCE=SQLEXPRESS net session >nul 2>&1 if %errorLevel% neq 0 ( echo Admin required & pause & exit /b ) ms sql server express portable
if ($Action -eq "Install") Out-Null Set-ItemProperty -Path $RegPath -Name "SQLArg0" -Value "-s$InstanceName" Write-Host "Service installed. Starting..." net start "MSSQL $$InstanceName"