First published on MSDN on Jan 24, 2018
You may want to know what registry keys will be added to system for a SQL server installation. If you use some registry snapshot tool to compare the window registries change of before and after the SQL installation you will find there are 40000~60000 modifications happening. However if you study the modifications carefully you will find that most of them doesn't have much sense, for example, lots of modifications go to "HKLM\DRIVERS\DriverDatabase\DeviceIds\" entry. The most interesting modifications are:
<>Installer related registry keys under
This tool pre-reads all SQL server meta data from setup source (the setup media containing those MSI/MSP files). The meta data includes product code, patch code,package code, files, registry keys will be added to system etc. It will then use this prepared meta data to scan registry and display only SQL server related in the UI. The tool will ask you to specify service pack or CU you ever installed to your system for an accurate report. you can browser/search/export the keys in the UI easily. Just be attention that this tool is not intended to list all SQL server related keys. Just those important ones will be displayed.