SSMS Tools Pack Works for Me

Today a co-worker of mine introduced me to a great add on to Microsoft’s SQL Server Management Studio (SSMS).  It’s simply called the SSMS Tools Pack and is a free download from http://www.ssmstoolspack.com/

The product is a collection of ‘a few upgrades to the SSMS IDE that I thought were missing” according to the author.  These features include:

  • SQL Snippets
  • Window Connection Coloring
  • Window Content History, Query Execution History and Current Window History
  • Format SQL
  • Search Table, View or Database Data
  • Run one script on multiple databases
  • Copy execution plan bitmaps to clipboard or file
  • Search Results in Grid Mode
  • Generate Insert statements from resultsets, tables or databases
  • Regions and Debug sections
  • Running custom scripts from Object Explorer
  • CRUD (Create, Read, Update, Delete) stored procedure generation
  • New query template
  • General Options

The particular feature I needed was to Generate Insert statements from an existing table – particularly when dealing with partial synchronizing between two copies of the same database, such as a Dev and Staging or Production environment.

I’ve added SSMS Tools Pack to all of my systems now, and is definitely one product I want to promote.

Leave a Reply