How to Compare Two SQL Queries in Notepad++

If you want two SQL queries to compare using Notepad++ you can follow the below steps.

• Copy the SQL Queries in Two Tabs in Notepad++ (or open the two .sql files)
• Now be on any of the tabs and go to Menu: Plugins > Compare > Set as First Compare (if you do not see Compare, follow the steps given below to install it)
  
• Now move to another SQL query tab/ and go to Menu: Plugins > Compare > Compare
  
• You will see the two files compared side-by-side with the differences highlighted as shown in the below screenshot.
  

How to install Compare Plugin in Notepad++

1. In Notepad++ go to Menu: Plugins > Plugin Admin...
2. Look for Compare under Plugin, select it and click on Install.
3. Notepad++ will get restarted and you should find Compare plugin under Plugins > Compare

This is not an AI-generated article but is demonstrated by a human on a Windows 11 PC with Notepad++ v 8.5.6 (64-bit).

Please support independent contributors like Code2care by donating a coffee.

Buy me a coffee!