SQL Refactor

Question

SQL Refactor

bledu

SSChampion

Points: 12335
More actions
March 6, 2007 at 9:12 am

#171546

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.

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

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

Matt Chandler Old Hand Points: 389 More actions · Answer 1

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

bledu SSChampion Points: 12335 More actions · Answer 2

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 SSC Veteran Points: 227 More actions · Answer 3

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 SSChampion Points: 12335 More actions · Answer 4

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 SSC Veteran Points: 227 More actions · Answer 5

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 SSCarpal Tunnel Points: 4170 More actions · Answer 6

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 SSChampion Points: 12335 More actions · Answer 7

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 SSC Guru Points: 148809 More actions · Answer 8

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 SSChampion Points: 12335 More actions · Answer 9

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.

sandipanghosh Valued Member Points: 50 More actions · Answer 10

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.

darenhan Valued Member Points: 64 More actions · Answer 11

where to get the sql prompt free bundle now?

-Daren

Joe Clifford SSCrazy Eights Points: 8739 More actions · Answer 12

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