SQL Refactor

  • I got the free bundle from Redgate through this site. I have managed to install the prompt but I am at a loss as to how to access the SQL refactor component.

    Help!


    Everything you can imagine is real.

  • SQL Prompt and SQL Refactor are separate products, so SQL Prompt doesn't have a SQL Refactor component.  You can download a free trial of SQL Refactor from the Red Gate website (http://www.red-gate.com).

    Matt ChandlerSoftware test engineer,Red Gate Software

  • Thanks Matt,

    I know that they are separate products. Below is the content of the readme file that comes with the sql prompt bundle that i got.

    --

    SQL Prompt Bundle

    =================

    (c) Red Gate Software Ltd 2004-2007

    Introduction

    ------------

    SQL Prompt Bundle contains the following products:

    - - - - - - - - - - - - - - - - - - - - - -

    SQL Prompt 3.0, for providing Intelligent auto-completion for SQL Server.

    SQL Refactor, for formatting SQL scripts, renaming objects, splitting tables and more.

    SQL Doc, for documenting one or multiple SQL Server 2000/2005 databases

    ------

    or maybe its just my spirit wanting free stuff.


    Everything you can imagine is real.

  • Hello,

    When you extract the files from the bundle you will have 3 separate files: one for SQL Refactor, one for SQL Prompt and one for SQL Doc.

    Did you receive a serial number for SQL Prompt or for the SQL Prompt Bundle?

    Rachel

  • i can't remember well but i think it was for the prompt. But the menu option for SQL refractor is disabled in Mgmt Studio.


    Everything you can imagine is real.

  • If you only received a serial number for SQL Prompt then unfortunately it will only enable the SQL Prompt tool and not SQL Refactor as well.

    SQL Refactor is available for a 14-day trial period but if you installed all 3 elements of the SQL Prompt Bundle when you received the free serial number for SQL Prompt then it is likely that the trial has expired.  

    Rachel.

  • You will find the program as a menu item in SSMS, along with SQL Prompt if you use it. There is an issue so if the menu item is greyed out read below...

    The issue you are experiencing with SQL Refactor and SQL 2005 SP2 where the Refactor menu is greyed out is a known problem with SQL 2005 SP2. There is a beta fix for this problem available - this can be downloaded from the following location:

    ftp://ftp.red-gate.com/SQLRefactorBeta/sqlrefactorsetup.exe

    There will be an official release of Refactor which will include this fix shortly, however hopefully this beta will solve the problem you are experiencing in the short term. Please keep an eye out for this official release.

  • Thanks, that managed to enable the menu option but unfortunately it seems my trial has expired.


    Everything you can imagine is real.

  • Yes - my free download also included SQL Refactor and SQL Doc but only had a licence key for SQL Prompt.  When I contacted Red Gate they apologised for any confusion and explained that the only free product on offer was SQL Prompt.

    John

  • You would think that they should have mentioned that in the download. 🙁

    ...marketing tricks.

    But irregardless, I would recommend this package to any SQL developer.


    Everything you can imagine is real.

  • HI

    I downloaded the files. but sql refactor sql 2005 manegment studio. with 2005 it's working. but only problem it's having 14 days trial.

  • where to get the sql prompt free bundle now?

    -Daren

  • sandipanghosh (9/22/2007)


    HI

    I downloaded the files. but sql refactor sql 2005 manegment studio. with 2005 it's working. but only problem it's having 14 days trial.

    Umm... not quite sure what you're trying to say here but if you've gone past your 14 days and like the product it's time to buy.

    Joe

Viewing 13 posts - 1 through 12 (of 12 total)

You must be logged in to reply to this topic. Login to reply