SQL files consolidation in SQL server installed systems

 

• Open Registry Editor by entering command as "regedit" in command prompt and click enter.
• You can see "HKEY_CLASSES_ROOT" as root folder. Just find folder "ssms.sql.11.0".
• Under that folder, you can see folder "Shell"
• Add New Key named as "Consolidate" for that folder by right click and select add new key
• Add new key for folder "Consolidate", Named as "Command"
• Now you can see right side panel, one key as "Default".
• Right click on the "Default" key and select "Modify" option from that and enter value as "C:\Program Files\SQL Script Consolidator\SQLScriptConsolidator.exe" "%1".
• You can see below for the folder structure and the value to be entered. 
• 

 

Please let me know if you face any problems while doing the modifications.