*** SQL Refactor 1.3 Released ***
This is a recommended upgrade for all current SQL Refactor users who would like to use SQL Refactor on SQL Server 2008 client.
â€¢ Fixed the disappearing dialog issue caused during Smart Rename.
â€¢ Fixed an exception caused while using â€˜Encapsulate as stored procedureâ€™
â€¢ Fixed a smart rename exception caused due to quoted identifiers.
â€¢ We believe that the reported layout hangs are fixed in this release version. However, some of those hangs were not reproducible in our test environment and so it was not possible to test every specific case.
â€¢ Foreign OSes will now display the SQL Refactor menu correctly in SSMS
Red Gate Software Ltd
Previous release history:
We've just released version 1.1 of SQL Refactor. Wed Mar 21, 2007
The following issues were addressed:
- SQL Refactor now supports SQL Server 2005 SP2 for SQL Server Management Studio.
- Stored procedure calls following a CREATE PROCEDURE statement no longer causes SQL Refactor to fail.
- SQL Refactor now supports xpath queries in SET statements.
- The OBJECT_NAME system function is now recognised as a system function.
- Fixed an issue where the Expand Wildcards feature had an adverse effect on square brackets.
- The Summarize Script feature now supports summarizing scripts that are part of SQL Server Management Studio projects.
Qualify Object Names:
- Updated the error message that occurs if a function cannot be found in the database.
- The DATEDIFF and DATEADD system functions no longer cause SQL Refactor to report errors.
- Fixed an issue where a table is incorrectly included in a column rename script when foreign key and primary key columns have the same name.
- INSERT statements now correctly obey the layout columns on single line option.
- DECLARE cursor statements now correctly preserve white space.
- Wrapping around CASE statements has been improved.
- The positioning of the FROM clause in DELETE and INSERT statements has been corrected.
- Improved layout for SET statements which use function calls.
- The AND keyword is now capitalised in BETWEEN clauses.
Find unused variables:
-The syntax EXEC @var = proc is now properly recognised.
- Variables used as OUTPUT parameters in stored procedure calls now have their assignments correctly detected.
- SQL Refactor now supports all types of SELECT assignments.
-Red Gate Software Ltd.
-Jonathan [dot] watts [at] red [dash] gate [dot] com
We've just released SQL Refactor 1.0. Tue Oct 31, 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 nearly 40 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.