SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


SQL Refactor


SQL Refactor

Author
Message
bledu
bledu
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1125 Visits: 104

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.

Matt Chandler
Matt Chandler
SSC-Enthusiastic
SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)SSC-Enthusiastic (113 reputation)

Group: Administrators
Points: 113 Visits: 406

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).



Matt Chandler
Software test engineer,
Red Gate Software
bledu
bledu
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1125 Visits: 104

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.

Rachel Hawley
Rachel Hawley
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 156

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


bledu
bledu
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1125 Visits: 104
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.

Rachel Hawley
Rachel Hawley
Grasshopper
Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)Grasshopper (21 reputation)

Group: General Forum Members
Points: 21 Visits: 156

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.


TDuffy
TDuffy
UDP Broadcaster
UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)UDP Broadcaster (1.4K reputation)

Group: General Forum Members
Points: 1448 Visits: 57

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.





bledu
bledu
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1125 Visits: 104
Thanks, that managed to enable the menu option but unfortunately it seems my trial has expired.


Everything you can imagine is real.

John Mitchell-245523
John Mitchell-245523
SSChampion
SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)SSChampion (13K reputation)

Group: General Forum Members
Points: 13976 Visits: 15939

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


bledu
bledu
Ten Centuries
Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)Ten Centuries (1.1K reputation)

Group: General Forum Members
Points: 1125 Visits: 104
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.

Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search