Plip's Weblog

Phil Winstanley - British .NET chap based in Lancashire. Enjoys tea and tech. Working for Microsoft.

SQL Refactor from Red Gate - FANTASTIC!

Well, Red Gate have done it again, they've come up with another fantastic product!

This time they've addressed and area which has been ignored for a *long time* with a tool which will help you refactor that *horrible* SQL code you crank out on a daily basis.

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:



foobar said:

Oh fark.  I might actually have to buy this thing.  It's very, very tempting.

# October 8, 2006 4:11 PM

Plip said:


Jon, You'd think so wouldn't you?

But this tool actually made me moist when I used it.

# October 9, 2006 5:18 AM

Gregor Suttie said:

Your comparing 2 different beasts aimed at different purposes at 2 distinctly different prices - comparing apples and pears doesnt work.

# October 9, 2006 2:23 PM

Paul D. Murphy said:

actually I'm not. vsts4db pricing hasn't been announced, so we don't actually know what it costs. however when you consider that it does significantly more than just refactoring the red gate product at $299.00 per user is probably not a very good deal.

for about 3k you can get an vs team suite (read msdn universal) which includes db pro. the value proposition makes this absolutely viable considering that the red gate tool is a plug in for sql server (which ain't cheap).

so vsts suite will get you the sql, it will get you the vs and it will get you the data tools. when you consider just how much more is offered, yea it costs more, but it's clearly a better value.

let's face facts here unless you are running pirated copies of vs and pirated copies of sql server, the costs of the msdn is negligible.


# October 9, 2006 5:58 PM

Mad Father Jerry said:

Visual Studio 2005 Team Suite (ie all editions, presumably including vsts4db when it comes out) costs $10,000+ up front, with an annual renewal cost of $3,500.

If you're a dev without MSDN then the dev edition of SQL Server costs $50.

I don't think a lifetime cost of (say) $20,000 for MSDN is 'negligible' when compared to $50 for SQL Server.

# October 11, 2006 4:37 AM