Menu
Are there any tools out there comparable to SSMS Tools Pack 2012? The licensing ($30 per machine, $100 for any number of machines.. for 3 months) leaves a lot to be desired and I wasn't sure of what other options are available.
For example, one thing that I really miss is the 'Save every query you run'. When tinkering and researching, it's been invaluable to have a running backup of different versions of queries as I run them. Or when I realize I don't have a backup of a query I was working on 2 months ago.
Clarification: SQL Server Management Studio's have no official addon support, but there are some tools out there. SSMS Tools Pack is one that I've been very fond of (2005, 2008 versions), but the licensing fee for 2012 is horrible. (I would pay for a reasonable license, but that's not the question here.)
I've found SSMS Boost for example that has some cool additions to SSMS that seem worth it.
What other addins are available for SQL Server 2012? I'd love to have something that saves a query when I hit F5 like SSMS Tools Pack does, or anything out there besides the two tools listed?
RBarryYoung2,66633 gold badges1515 silver badges4040 bronze badges
WernerCDWernerCD74011 gold badge77 silver badges1818 bronze badges
closed as off-topic by Paul White♦, Mark Storey-Smith, Max Vernon, RolandoMySQLDBA, Aaron Bertrand♦Jul 14 '14 at 20:18
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope.' – Paul White, Mark Storey-Smith, Max Vernon, RolandoMySQLDBA, Aaron Bertrand
4 Answers
I thought I'd have a play with this and for the stated goal of having something that 'Saves every query you run' that works on SQL Server 2012 SSMS this seems be do the job on my machine (Add your own error handling / testing / refactoring)
It's based off Andrei's sample project with the
Martin SmithConnect
class replaced. The SSMSAddin2012 project on Codeplex is also very useful.Martin Smith
65.9k1010 gold badges180180 silver badges264264 bronze badges
Some more info from SSMSBoost developer.As soon as you mentioned my project, I allow myself to write some words about the project. Kurukshetra malayalam movie. The main reason I have written the tool was that I have missed productivity features, concerning T-SQL Development and DBA - oriented tasks.For example:
- frequent connection switching between different servers
- writing 1000 times a day 'select * from '..
- export grid results to excel/xml
- keeping a list of favorite connections
- having a warning from SSMS when connecting to live-environment
all these and some other daily operations are adressed in SSMSBoost and have been constantly improved. Currently I release new version every 30-40 days. Over last 3 versions I have also got a lot of positive/constructive user feedback and lot of features were improved. Your proposal to save every executed query will be also soon implemented. As I wrote - if you want to have something special write me an e-mail ([email protected])
Andrei RantsevichAndrei Rantsevich
Another free and very nice and user friendly alternative is SQL Hunting Dog.
it works with SQL Server management studio 2008/2012 and gives you a much better navigation (however it has less features than ssmstoolpack.)
AlexTheDeveloperAlexTheDeveloper
It's not free but SqlSmash is also an addin for SSMS 2012, 2014.
Disclaimer: I am the developer for the product
LatishLatish
Not the answer you're looking for? Browse other questions tagged sql-serversql-server-2012ssms or ask your own question.
Ssms Tool Pack Free
Are there any tools out there comparable to SSMS Tools Pack 2012? The licensing ($30 per machine, $100 for any number of machines.. for 3 months) leaves a lot to be desired and I wasn't sure of what other options are available.
Ssms Tools Download
For example, one thing that I really miss is the 'Save every query you run'. When tinkering and researching, it's been invaluable to have a running backup of different versions of queries as I run them. Or when I realize I don't have a backup of a query I was working on 2 months ago.
Clarification: SQL Server Management Studio's have no official addon support, but there are some tools out there. SSMS Tools Pack is one that I've been very fond of (2005, 2008 versions), but the licensing fee for 2012 is horrible. (I would pay for a reasonable license, but that's not the question here.)
I've found SSMS Boost for example that has some cool additions to SSMS that seem worth it.
What other addins are available for SQL Server 2012? I'd love to have something that saves a query when I hit F5 like SSMS Tools Pack does, or anything out there besides the two tools listed?
RBarryYoung2,66633 gold badges1515 silver badges4040 bronze badges
WernerCDWernerCD74011 gold badge77 silver badges1818 bronze badges
closed as off-topic by Paul White♦, Mark Storey-Smith, Max Vernon, RolandoMySQLDBA, Aaron Bertrand♦Jul 14 '14 at 20:18
This question appears to be off-topic. The users who voted to close gave this specific reason:
- 'Shopping list question - questions about which tool, library, product or resource you should use are off-topic here because they quickly become obsolete and often are just about the preferences of the answerer. If you have an issue with or a question about a specific tool, please revise your question to conform to that scope.' – Paul White, Mark Storey-Smith, Max Vernon, RolandoMySQLDBA, Aaron Bertrand
4 Answers
I thought I'd have a play with this and for the stated goal of having something that 'Saves every query you run' that works on SQL Server 2012 SSMS this seems be do the job on my machine (Add your own error handling / testing / refactoring)
It's based off Andrei's sample project with the
Martin SmithMartin SmithConnect
class replaced. The SSMSAddin2012 project on Codeplex is also very useful.65.9k1010 gold badges180180 silver badges264264 bronze badges
Some more info from SSMSBoost developer.As soon as you mentioned my project, I allow myself to write some words about the project. The main reason I have written the tool was that I have missed productivity features, concerning T-SQL Development and DBA - oriented tasks.For example:
- frequent connection switching between different servers
- writing 1000 times a day 'select * from '..
- export grid results to excel/xml
- keeping a list of favorite connections
- having a warning from SSMS when connecting to live-environment
all these and some other daily operations are adressed in SSMSBoost and have been constantly improved. Currently I release new version every 30-40 days. Over last 3 versions I have also got a lot of positive/constructive user feedback and lot of features were improved. Your proposal to save every executed query will be also soon implemented. As I wrote - if you want to have something special write me an e-mail ([email protected])
Andrei RantsevichAndrei Rantsevich
Another free and very nice and user friendly alternative is SQL Hunting Dog.
it works with SQL Server management studio 2008/2012 and gives you a much better navigation (however it has less features than ssmstoolpack.)
AlexTheDeveloperAlexTheDeveloper
It's not free but SqlSmash is also an addin for SSMS 2012, 2014.
Disclaimer: I am the developer for the product
LatishLatish