SQL Refactor

Vi segnalo la possibilità di scaricare gratuitamente questo tool della Red-Gate, attualmente in fase di beta, che aggiunge alcune funzionalità a SQL Server Management Studio. Direttamente dal forum del produttore (Red-Gate), si segnala

In this release of SQL Refactor you can use the following features:


- SQL Lay Out reformats your T-SQL scripts. You can select this feature from the top level SQL Refactor menu. There are over 30 options to control this feature, these you can access from the top level SQL Refactor menu.
- Smart Rename renames functions, views, stored procedures and tables, and updates all the references to these renamed objects. You can select this feature from the context menu in Management Studio?s Object Explorer.
- Smart Rename parameters and columns renames parameters of stored procedures and functions, and columns of tables and views. You can select this feature from the context menu in Management Studio?s Object Explorer.
- Table Split splits a table into two tables, and automatically rewrites the referencing stored procedures, views, and so on. You can also use this refactoring to introduce referential integrity tables. You can select this feature from the context menu in Management Studio?s Object Explorer.
- Uppercase keywords turns keywords in your script or selection to uppercase.
- Summarize Script provides you with an overview of your script. By highlighting items in this overview you can see the corresponding statements highlighted in your script.
- Encapsulate as stored procedure turns your selection into a new stored procedure, and if requested, introduces a reference to it in your script.
- Expand wildcards expands SELECT * statements to include a full list of columns in the select part.
- Find unused variables and parameters shows you the variables and parameters in you script that are not used, or that are only assigned to.
- Qualify Object Names modifies the script so that all object names are qualified. You can select this feature from the top level SQL Refactor menu.

Per maggiori info

http://www.red-gate.com/messageboard/viewtopic.php?t=3438

Nella stessa categoria
    Nessuna risorsa collegata

    Commenti
    imperugo scrive:
    SQL Refactor

    Questa è una figata, io uso il loro sql prompt che mi sembra sia gratuito ancora per pochi giorni ed ho provato il profiler per .net veramente spettacolare.

    Lo provo al volo.

    Bella Luca !!!! ;)
    04/10/2006 ore 14.57

    Aggiungi un nuovo commento »»»
    Per inserire un commento, devi registrarti alla nostra community.

    © 1998-2008 - SQL Server a 360° - Il blog di Luca Bianchi

    TagCloud
    BLOG INFO
    • Post: 100
    • Commenti: 40
    • TrackBacks: 23
    • Feed blog e contenuti tecnici: RSS
    • Feed blog: RSS Atom OPML

    MVP
    CATEGORIE
    I PIÙ LETTI DEL MESE
    IN EVIDENZA