*** SQL Refactor 1.3 Released ***

Refactors and formats SQL code.

Moderators: Chris Auckland, David Atkinson, Anu Deshpande, Luke Jefferson

*** SQL Refactor 1.3 Released ***

Postby Ben Adderson » Mon Jul 28, 2008 12:16 pm

We are very pleased to announce the release of SQL Refactor v1.3. You can get it from

http://www.red-gate.com/products/SQL_Refactor/index.htm

This is a recommended upgrade for all current SQL Refactor users who would like to use SQL Refactor on SQL Server 2008 client.

Bug Fixes:

• 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


Kind regards,
Tanya Joseph
Project Manager
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:

General:
- 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.

Expand wildcards:
- Fixed an issue where the Expand Wildcards feature had an adverse effect on square brackets.

Summarize Script:
- 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.

Column Rename:
- 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.

Layout SQL:
- 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.

Uppercase Keywords:
- 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.
_________________
Jonathan Watts

-Red Gate Software Ltd.
-Software Tester
-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.
Ben Adderson
 
Posts: 79
Joined: Fri Apr 11, 2008 10:31 am
Location: Red Gate Software

Return to SQL Refactor 1

Who is online

Users browsing this forum: No registered users and 0 guests