[좐]군의 To-Be

SSMS 에 Add-in인 SSMS Tool Pack을 소개하려 한다. SSMS2005 버전과 SSMS2008 버전이 별도로 존재하므로 알맞은 버전을 설치해야 한다.
다운로드 : http://www.ssmstoolspack.com/Download.aspx

SSMS Tool Pack 은 다음과 기능을 제공한다.
( 필자의 경우 테이블에 데이터를 INSERT-SQL로 생성해주는 기능을 아주 유용하게 사용하고 있다.)

Features
Source : http://www.ssmstoolspack.com/Features.aspx

Window Connection Coloring

With windows connection color indicator you always know to which server you're connected to. The color strip can be docked to any side of the window and it's color can be easily changed from either it's context menu or from server coloring options.
Coloring for each server can be added, removed or just disabled.

Query Execution History (Soft Source Control) and Current Window History

Every SQL statement that you run is logged in a file on your disk or in a table in a database you specify with a connection string. This way, if you're working on some script you can get the full history of every change you've made between check-out and check-in of your file.
SQL Statements are saved in a list that is written to a file and/or a database with a timer which you can set to a desired interval.

Older query history logs can be auto deleted. Time after the logs are deleted is user settable.

Current window history is a dockable window that show queries executed in a currently active window. There is also a search box at the top that filters results as you type.

Search Table or Database Data

Simple search for a search term through all non-binary columns in a single table or in every table of a database. You can search in four ways: Contains, Starts with, Ends with and Equals.

Uppercase/Lowercase keywords and proper case Database Object Names

Set all keywords to uppercase or lowercase letters. Custom keywords can be added.
Format all database objects to their proper case sensitive name.

Run one script on multiple databases

Run selected or full window text on selected databases on the currently connected server. A new window is opened that contains one script for all databases.

Copy execution plan bitmaps to clipboard

Copy selected or all execution plans to a bitmap that is saved on the clipboard. Large execution plans that don't fit in the window are also copied in full.
Width of a picture containing all execution plans is equal to the width of the widest execution plan.

Search Results in Grid Mode and Execution Plans

Find all occurrences of your search string in the execution plans or in the results in datagrid mode.

Search results and execution plans Thumbnail

Generate Insert statements for a single table, the whole database or current resultsets in grids

Insert statements for the whole database are generated by the order of PK-FK relationships. Top tables with no FK's are scripted first. Binary data is by default fully scripted. If you wish you can also set the scripting data limit between 0 and 10 Mb. Larger values then the limit are then scripted as NULL.

Insert statements for the data in result grids are scripted into a new temporary table for each grid. For example from 5 result grids insert statements for 5 temporary tables get created.

Text document Regions and Debug sections

Regions behave in the same way as in Visual Studio. You can collapse them and expand them. Debug sections are sections that get commented or deleted when you change your script to Release configuration. A debug section is also a collapsable region. If you deploy a script in debug mode with added debug sections it will fail when run from SSMS without SSMS Tools Pack installed. You can of course comment those sections yourself by simply searching for start and end text of the debug sections.

Running custom scripts from Object explorer's Context menu

You can specify a custom script text, its name and node on Object Explorer on which you want to run it from. Node name, current database, current connection string and current server can also be specified in the custom script with keywords that are replaced with their respective values at script runtime.