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!
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 (www.red-gate.com).
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.
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
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:
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.
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
