Here's some steps on how to move your snippets to a different machine.
Locate your existing snippets folder. By default, it’s located at:
C:\Users\<your_username>\AppData\Local\Red Gate\SQL Prompt 10\Snippets
1. Copy the entire contents of this folder to your desired location
2. Update SQL Prompt to point to the new location
3. Open SQL Prompt, go to Options > Snippets
4. Click Add… and select the new folder where you copied your snippets. Your snippets should now be available in SQL Prompt in the new location
Using a shared folder for snippets
To share snippets across multiple machines, setting up a shared folder is the best approach.
1. Create a shared folder on a network drive or a cloud storage service (e.g. OneDrive, Dropbox, or a shared network location)
2. Copy your snippets to this shared folder
3. On each machine where you want to use these snippets:
- Open SQL Prompt
- Go to Options > Snippets
- Click Add… and select the shared folder
Now all machines will use the same set of snippets from the shared location.
Remember to adjust the paths according to your specific setup. If you encounter any issues please raise a support ticket.