We've just released a public beta of SQL Refactor.
SQL Refactor is an Add-In to Microsoft Management Studio. Therefore you must have Management Studio installed. SQL Refactor’s features are available from the Management Studio menus, which can access both SQL Server 2000 and SQL Server 2005.
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.
To install SQL Refactor beta download and execute the installer from:
ftp://ftp.red-gate.com/sqlrefactorbeta/sqlrefactorsetup.exeTo uninstall SQL Refactor beta:
- In Management Studio, select Tools -> Customize… .
The Options dialog box is displayed.
- Drag and drop the “SQL Refactor†menu from the main Management Studio menu bar onto the Options dialog box.
- Exit Management Studio.
- Execute the uninstaller.
If you have used the CTP of SQL Refactor, please uninstall it first.
Limitations
This is a beta release. There are known discrepancies between the documentation and the functionality. It will probably contain bugs. We would appreciate if you could post these on the forum or send them to us directly. While this beta is feature complete, any suggestions for future refactorings are welcome.
You are encouraged to read the documentation before using SQL Refactor.
Please do not install this version on a production machine.
Andras
Please note that the beta program is now over, and SQL Refactor was released on 31/10/2006.
SQL Refactor is an Add-In to Microsoft Management Studio. Therefore you must have Management Studio installed. SQL Refactor’s features are available from the Management Studio menus, which can access both SQL Server 2000 and SQL Server 2005.
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.
To install SQL Refactor beta download and execute the installer from:
ftp://ftp.red-gate.com/sqlrefactorbeta/sqlrefactorsetup.exe
To uninstall SQL Refactor beta:
- In Management Studio, select Tools -> Customize… . The Options dialog box is displayed. - Drag and drop the “SQL Refactor†menu from the main Management Studio menu bar onto the Options dialog box. - Exit Management Studio. - Execute the uninstaller.
If you have used the CTP of SQL Refactor, please uninstall it first.
Limitations
This is a beta release. There are known discrepancies between the documentation and the functionality. It will probably contain bugs. We would appreciate if you could post these on the forum or send them to us directly. While this beta is feature complete, any suggestions for future refactorings are welcome.
You are encouraged to read the documentation before using SQL Refactor.
Please do not install this version on a production machine.
Andras