Transcript Patch Uninstall Custom Actions

Patch Uninstall Custom Actions
Patch Uninstalls and Custom Actions
Requirement: Support for patch uninstall custom actions
Design Change: Provide a new custom action type that can be run during a patch
uninstall
Install SQL
SQL
Apply a SQL Patch
SQL
Uninstall the SQL Patch
SQL
Patch SQL
In addition to patching the database engine, the patch runs custom actions that create new tables
that are valid only for this version of the engine.
There is no way for the patch being uninstalled to run a custom action. This means state of the
system not truly back to pre-patched state.
4/10/2016
Microsoft Confidential
2
Anatomy of a Windows Installer Patch
Target MSI
Target
Files
MSP
Transform Target to
Upgrade
Payload
Upgrade MSI
Target MSI + Transform = Upgrade MSI
Upgrade
Files
Payload = Σ(Upgrade File - Target File)
Patch Uninstall Custom Actions: Under
the hoods
Apply a SQL Patch
Install SQL
Uninstall the SQL Patch
SQL Patch
SQL
Custom actions to patch and
un-patch the database
Cached
SQL MSI
MSI Datastore
Cached
SQL MSI
Cached
SQL MSP
Cached
SQL MSP
SQL MSP
In-memory SQL MSI
with
withthe
theun-patch
patch CACA
SQL 6.1
6.0
New
Table