SSMScripter is addin (plugin) for Microsoft SQL Management Studio which gives you ability to script database objects directly from SQL text editor or result grid into new editor window. It is also capable to run external program in currently used database context.
- Works with:
- SSMS 2012
- SSMS 2014
- SSMS 16
- SSMS 17
- SSMS 18
- SSMScripterScript
- Scripts database objects:
- stored procedures
- functions
- views
- tables
- triggers
- Binds to
F12
(like Visual Studio "Go to definition..." command) - Adds
Script...
command into context menu in SSMS 2012/2014:- sql text editor
- result grid
- Script by cursor position or provided text selection
- Scripts database objects:
- SSMScripterRun
- Open external program with additional arguments provided by database context:
$(Server)
- db server name ex INSTANCE/SQL2018$(Database)
- db name$(User)
- connected user name or domain user name$(Password)
- user password if provided$(ConnectionString)
- full connection string
- Binds to
Ctrl+F12
- Run from Object Explorer tree elements or SQL editor windows
- Open external program with additional arguments provided by database context:
- Its configurable from SSMS Options window (SSMScripter section)
- Download release build (https://github.com/mkoscielniak/SSMScripter/releases)
- SSMS 2012 - SSMScripter12
- SSMS 2014 - SSMScripter14
- SSMS 16 - SSMScripter16
- SSMS 17 - SSMScripter17
- SSMS 18 - SSMScripter18
- Turn off SSMS
- Unpack build content into (intermediate folders may not exists). If default SSMS installation path was changed take that into account:
- SSMS 2012 -
c:\ProgramData\Microsoft\SQL Server Management Studio\11.0\Addins\
- SSMS 2014 -
c:\ProgramData\Microsoft\SQL Server Management Studio\12.0\Addins\
- SSMS 16 -
c:\Program Files (x86)\Microsoft SQL Server\130\Tools\Binn\ManagementStudio\Extensions\SSMScripter\
- SSMS 17 -
c:\Program Files (x86)\Microsoft SQL Server\140\Tools\Binn\ManagementStudio\Extensions\SSMScripter\
- SSMS 18 -
c:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Extensions\SSMScripter\
- SSMS 2012 -
- Make sure all unpacked files are not blocked by Windows security (if so unblock them in file Properties)
- Run SSMS
- In SSMS 16 and 17 answer "No" in warning dialog about incorrectly loaded "ScriptCommandPackage" and then restart SSMS instance (warning appears only during first run after instalation)
- In SSMS 18 you have to manually bind SSMScripter commands into key shortcuts:
- open SSMS Options window (menu Tools->Options)
- enter Environment->Keyboard settings
- into
Show commands containing
textbox enterSSMSripter
to search for relevant commands - you can bind commands by:
- selecting where new shortcut will work (preferred
Global
or at leastSQL Query Editor
) - pressing selected keyboard shortcut
- and then clicking
Assign
button
- selecting where new shortcut will work (preferred
- bind
Tools.SSMScripterScript
command as Global, F12 - bind
Tools.SSMScripterRun
command as Global, Ctrl+F12