Monday, December 19, 2011

TOAD Vs. SSMS + Tools Pack

PROBLEM:
You are using TOAD for Oracle / SQL Server and searching for SSMS (SQL Server Management Studio) extensions to format SQL, generate insert statements, etc. Like in Toad

SOLUTION:
SSMS Tools Pack is the ultimate add-in for SSMS with the following great functionality:

CRUD (Create, Read, Update, Delete) stored procedure generation

Format SQL

Generate Insert statements for a database

Generate Insert statements for all grid results

Run one script on multiple databases

Search Database Data

Search text in grid results

SQL History Search - Query Execution History

Windows Connection Coloring

See more here: http://www.ssmstoolspack.com


If you find this solution useful, you are welcome to press one of the ads in this page.. Thanks!
Posted by at
Labels: , ,

2 comments:

  1. UnknownAugust 28, 2017 at 4:55 PM

    This comment has been removed by the author.

    ReplyDelete
  2. AnonymousNovember 13, 2018 at 12:35 AM

    There is a new version with a lot of functionalities for SSMS 2012, 2014, 2016, 2017, and 2019, it is also free, it's called "Michel Max - SSMS Tools"

    Functionalities :
    - Format SQL Code.
    - Prepare the Procedures/Functions to be called.
    - Regions to organize the code.
    - Retrieve the complete Information of a Table.
    - Tab Colorize, base in the configuration window you can colorize the existing session based in the filters that you applied, making easy to the developer to identify each server/database he/she is working on.
    - Selection Highlight for the same word in the SQL Code.
    - Style Markers for the same word in the SQL Code.
    - Configurable CRUD creation.
    - Copy/Paste Table Structure and Data (Client Side).
    - Grid Search, with advanced Extended and Regular Expression.
    - Grid Search Highlight.
    - Grid Style Markers.
    - Grid Export to JSON, Excel XML.
    - Grid Image Capture.
    - Configurable Header Text Template, with quick insert, so you can easily sign you codes.
    - Quick encapsulate code in region.

    https://sourceforge.net/projects/michelmaxssmstools2012/
    https://sourceforge.net/projects/michelmaxssmstools2014/
    https://sourceforge.net/projects/michelmaxssmstools2016/
    https://sourceforge.net/projects/michelmaxssmstools2017/
    https://sourceforge.net/projects/michelmaxssmstools2019/

    ReplyDelete

Subscribe to: Post Comments (Atom)