Thursday, 22 May 2025

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.

 

No comments:

Post a Comment

SQL_DBA- Ip Address Ping

Start-Transcript - path C:/Script/PingLog.txt -Append   Ping.exe -t spiceworks.com | ForEach { "{0} - {1}" -f (Get-Date), $_ } ...