Location of your SQL Templates and how to take them with you

If you have started to create a good collection of you own SQL Templates and snippets, then you may want to copy or share them from PC to PC or from user account to user account.

You will find your personal templates here

C:\Users\{username}\AppData\Roaming\Microsoft\SQL Server Management Studio\14.0\Templates\Sql\{your personal folder}

I regularly make a copy of my personal folder to my OneDrive and when arriving on a new PC with different user account, I copy this across to the location above.

The easiest way to keep things easy and simple to copy, is to create a personal folder and then sub-folders.

For more information on SQL Template Explorer see https://docs.microsoft.com/en-us/sql/ssms/template/template-explorer

Leave a Reply